Re: Total transactions by month

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.

.

Relevant Pages

  • Re: Total transactions by month
    ... > Countas Qty" (Date is the DateFieldName) and receive an error ... > message "The syntax of the subquery in this expression in incorrect". ...
    (microsoft.public.access.queries)
  • Re: Expression using multiple conditions
    ... The syntax of the subquery in this expression is incorrect. ... subquery's syntax and enclose the subquery in parentheses. ...
    (microsoft.public.access.queries)
  • Re: Certification Discussion
    ... You're syntax is incorrect. ... TGP MCNGP #100100 ... Prev by Date: ...
    (microsoft.public.cert.exam.mcse)
  • Re: Certification Discussion
    ... > You're syntax is incorrect. ... My Sin Tax has skyrocketed over the last year ... Prev by Date: ...
    (microsoft.public.cert.exam.mcse)
  • Re: Is there a fix for Access2003 rewriting (xxx) as [xxx]. ?
    ... The syntax. ... The first thing would be to stop using both the Graphical Designer and the ... You can also try to put the subquery into its own QueryDef or View. ... FROM Voters INNER JOIN BartonFarmPostcodes AS BF ON ...
    (microsoft.public.access.queries)