Update Query

esskaykay

Registered User.
Local time
Today, 13:11
Joined
Mar 8, 2003
Messages
267
I have a Select Query that counts the number of occurance. I would like to update a field in the table (or a different table) with the numbers returned by the count. I have attached a snapshot of my select query (query.jpg). Is this possible?

Thanks,
SKK
 

Attachments

  • Query.jpg
    Query.jpg
    38.8 KB · Views: 119
You shouldn't store this value, it can be obtained at any time via a query etc.
 
I understand and for the most part this works fine. However, I need this table for a GIS project we're working on.

Thanks,
SKK
 
Last edited:

Users who are viewing this thread

Back
Top Bottom