CREATING A QUERY IN ACC2003 THAT DISPLAYS CURRENT MONTH TRANSACTIO

  • Thread starter Thread starter Guest
  • Start date Start date
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]...
 
CURRENT said:
HOW DO I CREATE A QUERY IN ACCESS 2003 THAT ONLY DISPLAYS CURRENT
MONTH TRANSACTIONS???
Click to expand...

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.
 
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]...
 
Back
Top