var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Update query, starting at 1 to no. of records
I'm trying to use the update query to change a field in my table.
I would like to run an update query which will increment a value starting at 1 to the number of records which the query has pulled.
So if 5 records matched my criteria it would update say Field_X, starting at 1 to 5.
Record 1 Field_X = 1
Record 2 Field_X = 2
Record 3 Field_X = 3
Record 4 Field_X = 4
Record 5 Field_X = 5
Any ideas any one?
Hope this helps!
The problem with making anything foolproof...is that fools are so darn ingenious!
All posts/responses based on Access 2003/2007
thanks, some useful stuff on there.