MS Access Counter

Here is my issue:

The data in my database has multiple SS# per acct number

SS# 5678
acct# 1414

SS #1234
acct #1414

SS#9898
acct#1414

I need to post the data accros in on one row. I am doing that by doing an
update querry based on a group by count with participation great then one SS#.
However, I need to add the count to the table based on the ss# and account so
it would look like this:

1 SS# 5678
acct# 1414

2 SS #1234
acct #1414

3 SS#9898
acct#1414

How do I get the 1, 2, 3 to generate?

I know this is a bit confusing I did the best I could in explaining it.
THANKS!!

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...eries/200806/1

Here is a method for adding a counter to the Northwind employee table by title:

SELECT Employees.Title, Employees.LastName, Count(Employees_1.EmployeeID) AS
RankOrder
FROM Employees LEFT JOIN Employees AS Employees_1 ON Employees.Title =
Employees_1.Title
WHERE (((Employees.EmployeeID)=[Employees_1].[EmployeeID]))
GROUP BY Employees.Title, Employees.LastName
ORDER BY Employees.Title;

--
Duane Hookom
Microsoft Access MVP


"Laura1 via AccessMonster.com" wrote:

Here is my issue:

The data in my database has multiple SS# per acct number

SS# 5678
acct# 1414

SS #1234
acct #1414

SS#9898
acct#1414

I need to post the data accros in on one row. I am doing that by doing an
update querry based on a group by count with participation great then one SS#.
However, I need to add the count to the table based on the ss# and account so
it would look like this:

1 SS# 5678
acct# 1414

2 SS #1234
acct #1414

3 SS#9898
acct#1414

How do I get the 1, 2, 3 to generate?

I know this is a bit confusing I did the best I could in explaining it.
THANKS!!

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...eries/200806/1