I have a union query which combines data from 2 different databases located at different sites. Both databases are identical each of these databases does not allow duplication of field [Vol Ref] this does not stop their being a duplication as that Vol Ref could be entered once at each site and I have a duplicate when they are merged. I am trying to create a report that highlights duplicates. Below is the start of the code for my query:-
Expand|Select|Wrap|Line Numbers
- SELECT Union_Combined_Cadbury_Data.[Vol Ref], Union_Combined_Cadbury_Data.[Customer Name], Union_Combined_Cadbury_Data.[GP Agent], Union_Combined_Cadbury_Data.[Admin Agent], Union_Combined_Cadbury_Data.[Lead Product Type]
- FROM Union_Combined_Cadbury_Data;
I know I could do this in 2 queries 1 that does a count of VOL with criteria >1 and a second that lists the details and links it by Vol Ref to the 1st query where the join looks at where the Vol Ref is exists in both queries.
I would prefer if it can be done just to use 1 query as I keep getting lost when looking at my growing number of queries which I probably could in 1 query rather than using multiple queries.
all help is much appreciated