Date issue relating to table

[chris-uk-lad]

Hi all,

This is most likely a minor error on my part, Im trying to retrieve records from a column where the date is greater than 1st December 2008. I have 6 records as 05/01/2009 so this should work. Ive tried '01 December 2008', '#12/01/2008#' and '#01/12/2008#'

SELECT Name, Age FROM Report WHERE [Date Registered] > '#01/12/2008#'"

Many Thanks for the assist.

 

[JANR]

Try

Select Name, Age From Report WHERE [date Registered] > #12/01/2008#

JR

 

[DavidBoyleHerts]

Yes get rid of the single quotes. Also it's not a bad idea to get out of the habit of using spaces in your field names. Use the description property in the table to control how they display.

 

[chris-uk-lad]

worked a treat, thanks

 

[DavidBoyleHerts]

no problem drop me a line if you have any other issues. david.boyle@morrisonplc.com