I would like to have a parameter query which propmts for a date, then return all dates less than or equal to the date you put in, or if you leave the prompt blank, return all records. I have tried something like this <= like [Enter Date] &"*" but it doesn't work, does any one know how to get this to work, Thanks

Clean solution would be to conditionally build the SQL dfinition of your query. You could also cheat, trying something like:

<= Nz([Enter Date], #01/01/3000#)

Alex

Thanks.