I have 3 tables that are connected in a query by an ID number. Everything works well except that I get back 3 duplicate records instead of just one record. I attempted to try to fix this error by adding a group by first to one of the unique fields. However since I have a parameter up to prompt the operator for the ID number (this will bring up a set group of results for a time period) I get an invalid message saying that I cannot have a parameter and use the group by function.
Sorry if I wasn't very clear, but any help would be greatly appreciated. If any more information is needed just ask. Also I am using access 2003.
Sorry if I wasn't very clear, but any help would be greatly appreciated. If any more information is needed just ask. Also I am using access 2003.