I created a query and set criteria in one field to ask for a last name. When I run the query it does just that. Thereafter, I attempted to create a report from the query which I had done successfully in the past. However, when I then click on report it does not ask for a last name but produces a report on all 600 names in my database. I have done this with setting criteria in the past and it has worked but now I must be missing something. Any ideas? My criteria is Like"*"& [Enter Last Name]&"*"
I set it up this way so they could enter only part of the last name if necessary. Like I say, it worked previously but now it is not.
Thanks in advance.