[SQL] Where expression problem [SOLVED]

[Code.Illusionist]

Hello there, I am using Microsoft Access 2007 and this is my SQL code:

Code: [Select]

SELECT [First Name] , [Invoice Date]
FROM Customers AS c, Invoices AS i
WHERE (c.[First Name] LIKE 'A*') AND (i.[Invoice Date] BETWEEN #1/1/2006# AND #3/3/2006);
My table names are Customers, and as well Invoices, and table columns are First Name and Invoice Date. That's all from Northwind database.

I don't understand why my  SQL querry doesn't work.

[Code.Illusionist]

It was error simply saying: You have error at "Expression" , blah blah. I didn't create database, it's wide known Northwind database, avaliable in Access and on internet for use. They created Filed name like that, I would never do such thing, because I will have to use [] forever... For the wildcard, in SQL Access , we use * , but i am familiar with % as well.

And thanks, the true error was with # , i missed one. Such idiot. Thank you man.