I have a table with a lot of entries in it - the first field is packageID - this field only has numbers in it

I need to write a query that will find the entries that only appear once - every package must have a minimum of 2 entries - if not it will price wrong

The entries in the table will be different except the packageid - as each entry uses the same packageid as it's refence

Any advice would be appreciated

nylex,

In query design
Add the Package ID twice
Right Click on the first column
Select Total
Then where you see Order By--Select Count from the drop down list
In the criteria type 1
The datasheet view should then display all package that have only 1 entry

HTH

Thks - that worked fine