[AccessD] Splitting data from one row into two

I just saw this, change:

strSQL2="SELECT RRC_RRT,PayrollProcAcct,EarningsCode " & _
	"FROM SomeTable " & _
	"ORDER BY EmpID ASC;

to 

strSQL2="SELECT EmpId,RRC_RRT,PayrollProcAcct,EarningsCode " & _
	"FROM SomeTable " & _
	"ORDER BY EmpID ASC;

I added the EmpId field to the query.

Bobby

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gould, Nanette
Sent: Monday, April 24, 2006 1:40 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Splitting data from one row into two


Thanks! I'll give it a try and let you know if I hit any snags. 

Nanette