Syntax error

[TJVFree]

I’m getting a Syntax error when I’m trying to run this query. Can anyone help me figure out what is going wrong. It worked in other queries


Syntax error. In query expression ‘(Select count(*) from GP1_Master_Table_Count_Apps as B where GP1_Master_Table_Count_Apps. Customer Total > B.customerTotal)

Thank you for taking the time to help a newbe

 

[simian336]

Is this dynamic or regular? You started it out with a single quote and open paranthiese...

Customer Total would need to be .[Customer Total] no space before it.

Select count(*)
from GP1_Master_Table_Count_Apps as B
where B.[Customer Total] > B.customerTotal

Simi