Creating a view using access 2007

[rwill357]

I have been trying to run a command from the SQL view
I'm getting a syntax error

CREATE VIEW TopLevelCust AS
SELECT Customer.CustomerNum, Customer.CustomerName, Customer.Street, Customer.Balance, Customer.CreditLimit
FROM Customer
WHERE (((Customer.[CreditLimit])>=10000));

[drjohn]

Don't think you need the [ ... ] around CreditLimit

[debasisdas]

try this query

CREATE VIEW TopLevelCust AS
SELECT Customer.CustomerNum, Customer.CustomerName, Customer.Street, Customer.Balance, Customer.CreditLimit
FROM Customer
WHERE CreditLimit >= 10000;

[scoutwes]

Did you figure this out? I have to do the same thing and I'm getting the same error! I'm stuck!