Another quick question...
I can't seem to figure out how to use the Count function...

I want to count the number of occurences of a certain Text string in a field..

IE..
Table:
Feature ' String
Northing ' Double
easting ' Double
Elev ' Double
Inventory ' String
Comment ' Note

There are only 5 options for Inventory

GPS
Obscured (GPS)
CNL
Inaccessible/Impeded
EL

I want to count the Number of Each:

I tried:

SELECT Count([Final_MH]![Inventory]) AS Expr1, Final_MH.Inventory
FROM Final_MH
WHERE (((Final_MH.Inventory)="Obscured (GPS)"));

But MS ACCESS laughed at me!

Thanks again,
Jerry

Set this up in the QBE Grid and you will notice that you left out the Group By on the Inventory Field.

QBE GRID?

I guess this is the Design Grid...

Anyways I didn't know you had to use the Group By Function!!

I'm just poking around Access trying to figure it out!

Thanks, youre suggestion did make it work!

Thanks again,
Jerry