Hi, hope someone can unmuddle my brain here.

We have a db at work tracking all the phones, equip., fleet cars, etc. and
separate tables for each tracking the assigned users, who change throughout
the yr. Only 1 person has each piece of equipment at any one time.

example: main phone form has subform showing everyone who had that phone and
the start/end dates, most recent on top & descending. This is ok.

But another form needs to find the user that had the phone during a certain
date range, plus my rpts display costs by whichever user had the phone on
each invoice date.  So my criteria for InvDate parameter is "Between
[startdate] and [enddate]. Only way I can make this work so far is to put a
fake end date (2009 or something).

How can I leave the end date blank (for all current assigned users) and
still get only one user per invoice?

Thanks,