Count fuction

[funi.t]

hi
Is it possible to use the count function in access.for example if a certain shipping number appears more than once and i want my database to tell me how many times it appears

[pdebaets]

Search Access help for the DCount function. Ex."

dim i as integer
i = Dcount("*","MyTable","ShippingNumber = 123") '* Counts the number of records with shipping number 123

[funi.t]

is it not possible for access to pick different numbers and compare them.I have over 30000 shipping numbers so i cannot do it manually?

[pdebaets]

The following query will give you a count of the number of records for each ShippingNumber:

Select ShippingNumber, Count(*) as RecCount from MyTable Group By ShippingNumber Order By ShippingNumber;