I am trying to do a search querry to run a report , I want to do a search by full name (last, First, MI) is there a way I can combine my 3 colums and run the search
Thank You
I am trying to do a search querry to run a report , I want to do a search by full name (last, First, MI) is there a way I can combine my 3 colums and run the search
Thank You
Use something like this:
[Last] & " " & [First]& " " & [MI] AS FullName
I hope this is what you wanted
the code Like "*" & [Forms]![SearchF]![Last] & "*" works because it is showing the dates that I need to have shown, my problem is that I have multiple last names so I figure I would do a searh by the full name; (last, first, mi). when I use the code you provided it does generate the report but nothing shows up