Printing 30 day look ahead 1

[EllieFant]

I want to print a report that looks at the duedate column and prints all items due between the print date (the date the print button is pushed) ahead 30 days.

I know this would go in the critera of the duedate column in a query. I am just not sure what exactly would go there.

I tried between date() and +30

I need a hint please. Ellie
**Using Access 97**

lena.wood@wgint.com (work)
ellefant@bossig.com (home)

 

[dawnd3]

Hi Ellie, try: Between Date() And Date()+30 I have Access 2000, but I think that should work.

Dawn

 

[tlbroadbent]

Where DueDate Between date() And date()+30

OR

Where DueDate Between date() And DateAdd("d", 30, date()) Terry Broadbent
Please review faq183-874.

"The greatest obstacle to discovery is not ignorance -- it is the illusion of knowledge." - Daniel J Boorstin

 

[EllieFant]

Thanks Dawn, that seems to work just great!! Ellie
**Using Access 97**

lena.wood@wgint.com (work)
ellefant@bossig.com (home)

 

[dawnd3]

I am glad to hear that! If you don't mind, would you mark this post helpful so that it might help others...Thanks a bunch! Dawn