help with query please!!!!!!!!!!

[hinser13]

I ineed is a query that will return me all dates 30 days either side of a criteria date

 

[pbaldy]

This is a duplicate thread:

http://www.access-programmers.co.uk/forums/showthread.php?t=198756

 

[spn200286]

Someone pointed me to this in a diff thread and it helped me alot

http://www.datapigtechnologies.com/AccessMain.htm

It has a tutorial about loads of things including different date functions

(also according to the rules/general politness people wont make things for you without you atleast trying yourself)

 

[Trevor G]

I ineed is a query that will return me all dates 30 days either side of a criteria date

You might beable to use to expressions from the field, so something like this

Date()-30
Date()+30

If you have them as 2 seperate expressions that might work for you