Query Without Present Month

Question

Hi guys.

Please I need someone to give me a query formulae on how to query my table to give me all records except present month.

I don't want to use parameter as it will mean that I will always specify the duration.

All I want is every time I open the query, it should always give me all records apart from the present month I am in.

Thanks

Answer 1

Hi. Try something like:

Field: YourField

Criteria: < DateSerial(Year(Date),Month(Date),1)

Answer 2

Thanks to you theDBguy. It worked except that I had to modify it a little bit with this

<DateSerial(Year(Date()),Month(Date()),1)

Answer 3

Cool! Glad to hear you got it working. Good luck with your project.