Date function

[gj0519]

Is there a way that you can tell Access to pull data for the last full month? Like in Crystal Reports there is a function to do this.
Right now I have a parameter set where the user has to manualy enter in the start and end date. I would like for this to be automatic.
Thanks

 

[Databaseguy]

Where format(date(),""MMM,YYYY&quot = Mar2003

 

[GingerR]

more...

in your query, put a new field

Expr3: Format([Date],"mmmyy")

and it's criteria:

Format(DateAdd("m",-1,Date()),"mmmyy")

that will always figure out what 'last month' is, and only choose dates in that month.

g

 

[gj0519]

Thanks GingerR,
I will give that a try.

gj0519