HI,
I have a database with several tables related to the main table in a 1:M relationship. I have a select query that pulls information from these tables together. I have a form which enables me to search by any of the following fields by clicking on an associated button for each search combo
Name
Task
Process
Company
Customer
However each person may have multiple tasks, processes or customers assigned to them. I only want the results to bring back the first result as I only want one listing per person and then when the user clicks on the details he can see all of the other tasks and processes for this person. However when I add grouping to the query to show 1st result I find that my search macro no longer works as it was referring to the field name 'task' or 'Process' which no longer exists as in the query it is now 'firstoftask' or 'firstofprocess' is there anyway to refer to these in the macro? I have tried several versions and cannot get it to work.