Query based on the first of the month

[Guest]

I need to write a query that sort all information after the first on the
current month and year.

So any entery that was made after the first of the current month and year.
With out typing in the current month or year.

Any Ideas???

Thanks....

 

[Gary Walter]

I need to write a query that sort all information after the first on the
current month and year.

So any entery that was made after the first of the current month and year.
With out typing in the current month or year.

assuming no data for next month or beyond

WHERE [datefield] >= DateSerial(Year(Date),Month(Date),1)

 

[Allen Browne]

If you have a field named InvoiceDate, and you want it to show the first of
each month, type this expression into a fresh column in the Field row in
query design:
TheMonth: CVDate([InvoiceDate] - Day([InvoiceDate]) + 1)

If you want to limit the query to only entries for the current month, type
this into the Criteria row of your query, under the date field:
Between CDate(Date() - Day(Date()) + 1) And
DateSerial(Year(Date()), Month(Date()) + 1, 0)

 

[Guest]

Thanks Again....