Different Date Ranges...confirm

[MSherfey]

I'm doing a simple query to pull some transactions out of a table which fall into different ranges. In the first range all I want is from today to 90 days from now.

In the Criteria field for the 'Expiration Date' I used:

>=Date() AND <=DATE()+90. Will this work?

For 91-180 days I used:
>=Date+91 AND <=DATE()+180

Thanks!

 

[MSAccessRookie]

I'm doing a simple query to pull some transactions out of a table which fall into different ranges. In the first range all I want is from today to 90 days from now.

In the Criteria field for the 'Expiration Date' I used:

>=Date() AND <=DATE()+90. Will this work?

For 91-180 days I used:
>=Date+91 AND <=DATE()+180

Thanks!

What you have done used should work fine and do what you want. You also might want to consider using the BETWEEN keyword as an alternative (Syntax BETWEEN {StartDate} And {EndDate}).

 

[MSherfey]

Thanks. It seemed too simple so I had to check