Date search query

J

Jake2305

Joined
Jan 14, 2015
Messages
1
Reaction score
0
Hi

I am trying to set up a query whereby I search all entries within an area range with a end date between today and 6 months from today.

In the criteria for area I have: Between 0 And 599

I cannot find anything that works in the EndDate field though to produce all the data without having to manually enter the date. Is there a criteria where it will pick the current date and produce the 6 months worth of data or do you need to enter in a date+180 to get the results?

Any help would be much appreciated!

Thanks
J
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Criteria in a calculated query field 6
Between date and date query do not show values, how change this? 6
Query Date criteria 5
Date criteria in a query 4
Problem with date criteria in Query 2
Using Date parameters in select queries Access 2003 5
Problem with 1 Query with Criteria feeding another query 3
Date Range Query. Criteria based in a table. 4

Top