CREATING A QUERY IN ACC2003 THAT DISPLAYS CURRENT MONTH TRANSACTIO

[Guest]

HOW DO I CREATE A QUERY IN ACCESS 2003 THAT ONLY DISPLAYS CURRENT MONTH
TRANSACTIONS???

 

[James]

STOP SHOUTING... then make a query like this:

SELECT * from YourTableName WHERE year(YourDateField) = format(now,"YYYY")
and Month(YourDateField) = format(now,"m")


"CURRENT MONTH TRANS QUERY (ACC2003)" <CURRENT MONTH TRANS QUERY
(ACC2003)@discussions.microsoft.com> wrote in message
news:[email protected]...

 

[Rick Brandt]

HOW DO I CREATE A QUERY IN ACCESS 2003 THAT ONLY DISPLAYS CURRENT
MONTH TRANSACTIONS???

SELECT *
FROM TableName
WHERE DateField BETWEEN
DateSerial(Year(Date()), Month(Date()), 1)
AND DateSerial(Year(Date()), Month(Date()) + 1, 0)

If the DateField includes time then change final zero to a one.

 

[Linda Burnside]

Try something like this:

SELECT Month([transdatefield]) AS transdatemonth, YOURTABLE.transdatefield,
YOURTABLE.transactioninfo
FROM YOURTABLE
WHERE (((Month([transdatefield]))=Month(Now())));

"CURRENT MONTH TRANS QUERY (ACC2003)" <CURRENT MONTH TRANS QUERY
(ACC2003)@discussions.microsoft.com> wrote in message
news:[email protected]...