A Date falls within two Dates.

[hooi]

I would like to know what internal function I can use to so that I can determine whether a Date given by the user falls within two previously entered Dates.

Thanks...

 

[hooi]

Just to further clarify my question.

The Date given by the user is for a field in Table A (Date of Registration).
The two previously entered dates are two separate fields in Table B (eg. BeginDate and EndDate)

 

[WayneRyan]

Hooi,

Look up the Between function, you can use it in a query.

You can use the Help files or the Search facility here.

Wayne

 

[hooi]

Thanks... It works!