CREATING A QUERY IN ACC2003 THAT DISPLAYS CURRENT MONTH TRANSACTIO

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

CURRENT MONTH TRANS QUERY (ACC2003) - 20 May 2005 23:26 GMT

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

Reply to this Message

James - 21 May 2005 00:05 GMT

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

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

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

Reply to this Message

Rick Brandt - 21 May 2005 00:06 GMT

> 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.

Signature

I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

Reply to this Message

Linda Burnside - 21 May 2005 18:59 GMT

Try something like this:

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

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

Reply to this Message