Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Get max out of table and replace all zero by max+1

Status
Not open for further replies.
Kweker

Kweker

Programmer
Joined
Feb 4, 2002
Messages
12
Location
NL
Is it possible to find all the fields(schoolID) out of table scholen that are zero, then select a few or all of these records, then find maximum [schoolID] and fill the selected [schoolID]."table scholen" with each time maximum number + 1.
 
Status
Not open for further replies.

Similar threads

ameedoo3000
  • Locked
  • Question Question
Clear all table contents without deleting records
Replies
15
Views
2K
ameedoo3000
ameedoo3000
A
  • Locked
  • Question Question
Print Table attachment
Replies
2
Views
524
andre.meyer
A
ameedoo3000
  • Locked
  • Question Question
format partition by vba code
Replies
6
Views
1K
mattKnight
mattKnight
OCM
  • Locked
  • Question Question
Populate access table from excel
Replies
6
Views
6K
OCM
OCM
YoBi4Ever
  • Locked
  • Question Question
I would like to compute how many minutes or hours the employee left work by comparing two records
Replies
3
Views
626
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top