Agregation function - where clause

[Khalil Handal]

Hi,
I have a table with 42000 records, I want to edit some records based on the following condition: count of a field1 is < 2.
My form will display only the records that has the condition (the count <2) so that I can edit these records.
Is there a way?
I am using access 2010 .mdb file



Khalil

[Homegrownandy]

are you comfortable creating the query to count it?

[Khalil Handal]

Hi,
What I am actually doing is cleaning the data in a flat database in order to migrate it to a relational database.
Some fields are repeated 89 times in 89 different records, so I create an update query to edit this field.
There fields having only one occurrence in one record only. What I was thinking of is to have query showing only the records that has one occurrence for a specif field , build a form in datasheet view based on this query to enable me to edit these records.

Khalil

[aytee111]

Create a Find Duplicates query using the wizard, select only field1. It will show all records with field1 having a count >1. Change the criteria to say =1 instead.