wildcard parameter query

[Engelking]

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

 

[Alexandre]

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

 

[Engelking]

Thanks.