Hello,
I have a query that provides information from my primary table using a parameter requesting a name (Last, First). I would like to satisfy the parameter using only the last name.
The first field of my query is "Study Coordinator (Main)" from my "BasicTable". For the criteria of this field that sets the parameter, I have "[Study Coordinator (Last, First)]", the title of another table that lists all of the possible Study Coordinators. This table lists the last name in one field and the first name in the other. Using a separate query I concatenated the two, which I then used in a combo box on a form that then enters the concatenated name into Basic Table.
In the query I am concerned about, I want to pull up study coordinators by using their last name only, not their full name. Is this possible?
Thanks so much!