Current Month

[Al V]

In a query, how do I ask for Invoice Date (this query has
to do with receivables) for this month only. Without
having to put the month number in each time?

TIA
Al

 

[Cheryl Fischer]

In your query's design view, try adding two new fields as follows:

In the Field: row: Year([InvoiceDate])
In the Criteria: row: Year(Date())

In the Field: row: Month([InvoiceDate])
In the Criteria: row: Month(Date())



hth,

 

[Guest]

How about..

SELECT Month([RecDate]) AS Expr1, RScores.RecDat
FROM RScore
WHERE (((Month([RecDate]))=Month(Now())))

 

[Brian Camire]

You might also try criteria like this on your Invoice Date field:

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

Month(Date()) + 1, 0)