Search results

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...

I wonder if anyone can point me in the right direction. I want to export an Access report grouped by 49 different categories with Page breaks at each category. The hard part is I want each Category to go to a different worksheet in the same Excel Workbook. The users want it in excel to work with...