Access query problem

[meden]

Hi folks
I'm playing about with a copy of the Access database with a view to generating various management reports.

I want to build a query where I can select all the orders place between certain dates and the response to the 'Where did you hear about us?" question at checkout.

I've hit a snag whereas it appears all the dates in all the tables appear to be input as text and not using the Date/Time format - so I can't see a way of filtering between 2 dates.

I am only just starting out with Access so wondered if I'm missing something really basic or does Actinic indeed populate all the date fields as text?

[Mike Hughes]

I've never had any problem using this format for date selection.

WHERE (Order.`Date Ordered`>='2011/01/01 00:00' And Order.`Date Ordered`<'2012/01/01 00:00')

Mike

[meden]

Thanks Mike - couldn't get that to work for some reason, so I just changed the field property to 'Date/Time' format and entered this as my criteria in '[Query]Design View'

>=#18/01/2012# And <=#26/01/2012#

And it does what I expected now