Add a sequence to a group of records in a query

R

RichieTJ

This is the situation:

I want to add a sequence to a group of records in a query that meet
certain criteria. Example:

GroupID AreaID EmployeeID SequenceNo
(Field to add)
12345 123 458XA
00001
12345 123 452CA
00002
12345 123 538CD
00003

Where GroupID and AreaID are the criteria.

How do I assign that sequence?


Thx
 

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 Access 2007 Delete Part of Text 0
Have a user imput the number of records a query returns 1
Using a Public Variable in a Query - Passing Through a Function 3
Add sequence number for records 2
Query returning duplicate/unexpected results 3
Access 2000 append unbound text box values to a table 0
Formatting the results of a Make Table Query when running it 2
How to get this table updated with a result from another query 2

Top