Will,
> However, if I enter dates, they seem to be ignored, and the query
> just pulls
> out all instances if I have only entered a start date and none if
> I enter a
> start and an end date.
>
> Either way it's not working.
>
> Any suggestions?
>
Have you had a look at the CF debug info to see what query is actually being
generated and tried that query directly in Access??
It might just be that there isn't any data available for the dates you put
in... ;o)
Regards
Stephen
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists