How to "count" items in a query

[Valerie123]

Access 97: I have a query with 2 fields. One field show several numbers. I would like to total all the same numbers. Example 01 shows up a total of 3 times. 07 shows up a total of 10 times etc. Any simple language help would be appreciated.

Thanks,

Val

 

[sfreeman@co.mer]

Try this...

SELECT
tblNumbers.NumberField
, Count(tblNumbers.NumberField)

AS
CountOfNumberField

FROM
tblNumbers

GROUP BY
tblNumbers.NumberField;
HTH

 

[Valerie123]

Sorry, I'm lost

Can you tell me how to insert this code

Thanks,

Val

 

[darcy]

I guess it would be in sql mode for the query.

Click on the drop down arrow next to View and choose sql view