Search results

In the original example I should have been more clear. My source file has Location and Function as the first two fields. I have imported this into an Access table and will have to reload several times a year. Original source is sorted by Location then function and looks something like this...

Thanks. That seems to get me part of the way there. That technique gives me a "1" for each record. What I am trying to accomplish is a running talley of location. So if I have 5 locations = 001, then I would like to see the number column show 1-5. If I reload my source file and now there are...

I have a query with 40 fields and 16,000 records. Field 1 is Location, of which I have 197 unique values. What I would like to do is have a running count for each unique location and when the location changes start the count over again. Example Count Location Function 1...