Thanks Vladimir, that's the missing piece :)
Kira
kira
Last Activity: Sep 14 '06, 01:56 AM
Joined: Sep 8 '06
Location:
-
Hi Vladimir,
You're right. Adding a Group By on ID to the first query did produce slightly different results. It eliminated the Id column. What I meant when I said it produced the same results is it returned all the same records and didn't solve the problem with the ActionCode column.
The first query (the code in my last post) has been fine from the start. It returns all duplicate EmployNames. What I need to figure...Leave a comment:
-
Thanks - PEB
I tried the Group By on Id and it returned the same results as first query.
To be honest I'm uncertain whether I need a second query or just need to add another statement to the first query code:
...Code:SELECT Summary.ID, Summary.EmployID, Summary.EmployName, Summary.ActionCode, Summary.Location, Summary.EffDate, Summary.Unit FROM Summary WHERE (((Summary.EmployName) In (SELECT
Leave a comment:
-
Trouble with Query
I'm trying to create a query based on a single table with 7 fields. The ID field may be the only unique field in each record. The two fields queried are Name and Action which both may appear in multiple records.
First I ran the find duplicates wizard on the name field and came up with:
Id Name Action
456 Anne a
823 Anne a
322 Anne ...
No activity results to display
Leave a comment: