Using two dates to determine if someones on site...

[Adzi]

Hi,

I need a little help with my Query design.

I have an Arrival Date and a Departure Date for campers checking in on a campsite. I need to produce a report for the warden to have to check who's on site.

So far, the best way I though was using a new field in the query for "On Site" (which isnt in the control table) and then using an expression such as...

[Date of Departure] < Date()

However this isnt working, probably for some silly oversight on my behalf.

Any help?

Thanks, Adzi.

 

[neileg]

<Date() should be the criterion in your [date of departure] field in the query.

 

[Soma_rich]

Could you not just query the table with the 2 dates and haev a critera under the depart date is null?