Query Help

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a way to set a defalt to pick up the last 13 months?
I am using a between date range and would like to have a code to avoid
changing the dates...
If so please assist...
 
Is there a way to set a defalt to pick up the last 13 months?
I am using a between date range and would like to have a code to avoid
changing the dates...
If so please assist...
Click to expand...

Between Date() and DateAdd("m",-13,Date())

will return records between 4/26/2006 and 3/26/2005

Is that what you want?
 
You must log in or register to reply here.

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

Query by current date using month & year 5
Date search query 0
Query Parameters 1
Excel Message box with days of month & date. 1
Please help with Access query 0
Query for previous week, Sun thru Sat, from date field 1
Excel VBA to go to specific sheet & cell in the current workbook not working. 2
IIF with Dateserial and Between 2

Back
Top