Update Query Question

  • Thread starter Thread starter Treebeard
  • Start date Start date
T

Treebeard

Is there any way to set a Count field using an update query? I want this
field to have the value 1 to N where N is the number of records returned
from the query?

UPDATE tblTableName SET [Count_field] = ????

Jack
 
The number of records returned from WHAT query? Most likely, you would have
to write some VBA code to do this because access will not allow an aggregate
function to be used in an Update statement.
 
Back
Top