Calculate between certain dates

[madrappin]

Can anyone help me type this up right? The error I keep getting is "Error: Expected End of Statement" with the BETWEEN highlighted. Everything looks right to me, but I'm not very good with VBA. Thanks for any help.

DoCmd.OpenReport Me.lstReport, acViewPreview, , tblData.[GC DATE] BETWEEN Now() AND DateAdd("yyyy",-1,Now())

 

[PHV]

You may try this:
DoCmd.OpenReport Me.lstReport, acViewPreview, , "tblData.[GC DATE] BETWEEN DateAdd('yyyy',-1,Now()) And Now()"

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[madrappin]

Awesome that works great! Thanks