select COUNT function

[jmcilhinney]

COUNT is a function and its parameter list must be enclosed parentheses:

SELECT COUNT([f0011AccNumber]) FROM [t0011Journal]

Also, there's no point specifying a column to COUNT as the number of records is the regardless:

SELECT COUNT(*) FROM [t0011Journal]