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!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Add sequence number and restart for each emplid
I don't think it is possible in a query so I was thinking that a module would be necessary. The query pulls data from a table and adds some additional default fields. The query name is PG_COMM. The main fields are: EMPLID EARN_CD EARN_AMT EARN_BEGIN_DT EARN_END_DT I need to add the sequence...- 8172
- Post #3
- Forum: Microsoft: Access Modules (VBA Coding)
-
Add sequence number and restart for each emplid
emplid SeqNbr 22222 1 22222 2 33333 1 33333 2 33333 3 55555 1 I have a query which has emplids. I need to add a sequence number that restarts numbering for each emplid. See example of the goal above. Thanks!- 8172
- Thread
- Replies: 4
- Forum: Microsoft: Access Modules (VBA Coding)
-
Character Criteria
WHERE len(fieldname) = 6- 8172
- Post #3
- Forum: Microsoft: Access Queries and JET SQL
