I am struggling with a query. I am working on an Xtab that will show me the number of times a particular "ZCategory" is occurs. In order to do this, I first need to create a query that has the data for me to run an Xtab on. This query, called ZQuery1 is causing me problems.
ZQuery one needs to have the following fields "IDNumber" "ZDate" "Activity" "Locale" Locale2" "Locale2Att" "Locale3" "Locale3Att" "ZCategory" "CatAtt1" and "CatAtt2"
There can be multiple "ZCategorys" linked to a single "IDNumber". But I do not want to include records that show the same "ZCategory" value linked to the same "IDNumber". For example, I do not
IDNumber ZCategory Activity
Locale
.....
147852 Blue Beta GRB ..... 147852 Red Beta GRB ..... 147852 Blue Beta GRB .....
I only want to see
IDNumber ZCategory Activity Locale ..... 147852 Blue Beta GRB ..... 147852 Red Beta GRB .....
I achieve this using MS Excel all the time by clicking on 'Remove Duplicates' and selecting both columns. I do not know how to do this through Access queries.
In other words, I want to make a query where: IF Column(1).Value and Column(2).Value appear multiple times, THEN show one one row