an INSERT problem

[DougieC]

hello there,
I am trying to do an insert into a table with an autonumber for the AgencyID. Here is the SQL

INSERT INTO Agencies (AgencyID, CompanyName, Address, City, StateOrProvince, ContactName, Phone, webSite, Fax, TollFree, Email, CompanyLogo) 
VALUES ('null','blah', 'blah', 'blah', 'British Columbia' 'blah', 'blah', 'blah', 'blah', 'blah', 'blah', 'blah') 

I am getting this error :
Invalid Insert: Column count doesn't match value count at row 1

I don't understand why it is doing this? I have the exact amount information that is going into the table.
Can anyone please shed some light on this😕

[drawmack]

you're missing a comma after british columbia, but it's still not going to work. Remove the null in the begining and the autonumber field from the fields list too.

[DougieC]

OMG LOL, i was stuck on that for an hour😃 Thanks alot man