Update Query Question

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
 
L

Lynn Trapp

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Updating inventory levels 0
You must use the dbSeeChanges option with Open Recordset whenaccessing a SQL Server table that has a 1
Update top n records 16
Access Dcount (multiple criteria) 3
Incremental Numbering 5
Option Group Value Pass to Query 2
Ecount on filtered records 1
Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1

Top