Unanswered: Quick Access Query Question - I think?
I am trying to design a query to identify instances when, for every instance of the data in Field1, the data in Field2 field varies. Both fields can contain duplicated data. For example with the following data:
Thank you for your very prompt response. I copied the code into Access 2003 which changed it to the following:
SELECT Data_Ref, Field1
FROM [SELECT DISTINCT Data_Ref, Field1, Field2 FROM myTable; ] AS T
GROUP BY Data_Ref, Field1
This gives an error as Access is looking for the table named between the square brackets.
Also, I think this might give no records as Data_Ref is a unique number in all records?
I have tried to adapt the query but with no success
It might help to explain further - I require a report of all the records where Field1 has varying Field2's and ideally the report would give all the records where this occurs - i.e the report would produce 10 records in my example (total 13 records less the 3 records with 31 in Field1).