CREATING A QUERY IN ACC2003 THAT DISPLAYS CURRENT MONTH TRANSACTIO

  • Thread starter CURRENT MONTH TRANS QUERY (ACC2003)
  • Start date
C

CURRENT MONTH TRANS QUERY (ACC2003)

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

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

Rick Brandt

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

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