Re: Total transactions by month

FJB wrote:
> I entered the first line as "SELECT Format(Date, "yyyymm") AS YrMnth,
> Count(*) as Qty" (Date is the DateFieldName) and receive an error
> message "The syntax of the subquery in this expression in incorrect".
> I failed to mention I am using Access 2002 (XP) if that makes a
> difference.

"first line"? What I posted you would paste into the SQL view of a new query
and then change the names of the fields and table to match yours.

Also, you should change the name of your field "Date" as that is a reserved word
in Access. As written Access would likely think you meant the function named
"Date" rather than your field named "Date".

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


.

Relevant Pages