[AccessD] Splitting data from one row into two

I haven't had a chance to test it yet so I'll make that change before I
do. 

Thanks!
Nanette

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Bobby Heid
Sent: Monday, April 24, 2006 1:27 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [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

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com