sql command in access to view particular date in a data

[learning_grexcel]

I want to view a data in MS Access using SQL command. The data contains one column of "Date" as below
Date >> Company >> Purchased item
01.06.2011 >> A >> pen
01.06.2011 >> B >> rubber
02.06.2011 >> A >>> pencil
03.06.2011 >> A >> pencil

Now I want to view sale of only 1st June, how I can do that?

i tried the following
Select date, company, purchased item
From tablename
WHERE Date = 01.06.2011

But it doesn't show output.

 

[xenou]

Select date, company, [purchased item]
From tablename
WHERE Date = #01.06.2011#

1) put brackets around field names with spaces in them (or better, just don't use fields names with spaces in them)
2) put # symbols around literal dates
3) We assume that you do have true dates and not dates stored as text.
4) Date is not a good name for a field in Access as it is a reserved keyword in VBA for the DATE() function - obscure problems can arise when you use reserved words as the names of fields or tables.

Using the query design grid and then changing to SQL View is a good way to check your understanding of Access SQL syntax.