Union Query

  • Thread starter Thread starter pago
  • Start date Start date
P

pago

Hi everyone,

Can anyone have a look at my union query below, because Access keeps
telling me that I have got a “Syntax Error (missing operator) in query
expression ‘[Account Code]’ = “AAA-071153”


SELECT [Account Code], [Amount], [Transaction Date], [Transaction
description], [Period], [Debit/Credit], [Journal No], [Journal Type],
[Journal Source], [Transaction Reference]
FROM [BAT_1997]
WHERE [Account Code] = “AAA-071153”

UNION SELECT [Account Code], [Amount], [Transaction Date],
[Transaction description], [Period], [Debit/Credit], [Journal No],
[Journal Type], [Journal Source], [Transaction Reference]
FROM [BAT_2007]
WHERE [Account Code] = “AAA-071153”


What is Access trying to tell me?


Many thanks,


Pb
 
It looks like you have "smart" quotes in what you have posted.

I don't know if that is the actual case or if they got introduced when you posted.

WHERE [Account Code] = “AAA-071153”
should be
WHERE [Account Code] = "AAA-071153"

If you retyped the query SQL instead of copying and pasting it from the SQL
window, then you are asking us to trouble-shoot your typing and not the SQL of
the query.

John Spencer
Access MVP 2002-2005, 2007-2011
 
It looks like you have "smart" quotes in what you have posted.

I don't know if that is the actual case or if they got introduced when you posted.

WHERE [Account Code] = AAA-071153
should be
WHERE [Account Code] = "AAA-071153"

If you retyped the query SQL instead of copying and pasting it from the SQL
window, then you are asking us to trouble-shoot your typing and not the SQL of
the query.

John Spencer
Access MVP 2002-2005, 2007-2011

Hi everyone,
Click to expand...
Can anyone have a look at my union query below, because Access keeps
telling me that I have got a Syntax Error (missing operator) in query
expression [Account Code] = AAA-071153
Click to expand...
SELECT [Account Code], [Amount],  [Transaction Date], [Transaction
description], [Period], [Debit/Credit], [Journal No],  [Journal Type],
[Journal Source], [Transaction Reference]
       FROM [BAT_1997]
       WHERE [Account Code] = AAA-071153
Click to expand...
  UNION SELECT [Account Code], [Amount], [Transaction Date],
[Transaction description], [Period], [Debit/Credit], [Journal No],
[Journal Type], [Journal Source], [Transaction Reference]
        FROM [BAT_2007]
       WHERE [Account Code] = AAA-071153
Click to expand...
What is Access trying to tell me?
Click to expand...
Many thanks,
Click to expand...
Pb- Hide quoted text -
Click to expand...

- Show quoted text -
Click to expand...


Hi John,

Please excuse my post as I am not a programmer by trade, let anlone an
MVP. Originally I copied and pasted my SQL query from Word to
Access.

The only thing that I changed was the account code but everything
stayed as it is, including the “smarts”.

Just interestingly enough when I copied and pasted the same original
query from Notepad to Access this morning, the same query was accepted
by Access. how strange!

This leads me to think that Word may have applied some formatting that
Access didn’t like.

Correct me if am wrong.


Regards,

Pb
 
Back
Top