txtbox returns current user only

[Lungta]

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,

 

[Douglas J. Steele]

Try:

Between [startdate] and Nz([enddate], #9999-12-31#)

 

[Lungta]

Oh boy, it works great! You rock! Thanks.
--
Lungta

Try:

Between [startdate] and Nz([enddate], #9999-12-31#)



--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

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,