Hi -
I have a file of transactions, and the first line of the transaction
contains the transaction number, type and date (and a few other
fields). The following lines (there could be 1 to as many as 100 or
even more) have only some of the fields filled in - it's not
consistent - it all depends on the transaction.

I would like to get some sort of unique identifier - like the
Transaction number - on every line related to that transaction, so I
can ulitimately import the data into another system (probably have to
go through Access first.

I cannot think of how to do this! Can someone help? Here's an
example. Below are 3 transactions. I split them up and repeated the
header here, so it would display in a way it would make sense. I do
not need the TOTAL line - and that line is not indicated with the word
"Total". (No help there).

Trans # Type Date Num Name Memo Item Item Desc
413209 Bill 10/01/2011 100111 Jones
Jones Coffee
Account Qty Debit Credit
A/P - Trade 210.02
Other 210.02
210.02 210.02

Trans # Type Date Num Name Memo Item Item Desc
419986 Payment 10/03/2011 12221 CC Smith
Smith
Account Qty Debit Credit
UndepFunds 682.11
A/R - Trade 682.11
682.11 682.11

Trans # Type Date Num Name Memo Item Item Desc
486672 Invoice 10/22/2011 202513 Grady
Grady Unit 1 West 11 descr West
West Non-Tax Non-Tax
Account Qty Debit Credit
A/R - Trade 275.00
South 2 -5.00 275.00
Sales Tax Pay 0.00
275.00 275.00

Thanks -
Sara

On Nov 16, 9:47*am, Sara wrote:
Hi -
I have a file of transactions, and the first line of the transaction
contains the transaction number, type and date (and a few other
fields). *The following lines (there could be 1 to as many as 100 or
even more) have only some of the fields filled in - it's not
consistent - it all depends on the transaction.

I would like to get some sort of unique identifier - like the
Transaction number - on every line related to that transaction, so I
can ulitimately import the data into another system (probably have to
go through Access first.

I cannot think of how to do this! *Can someone help? *Here's an
example. *Below are 3 transactions. I split them up and repeated the
header here, so it would display in a way it would make sense. *I do
not need the TOTAL line - and that line is not indicated with the word
"Total". (No help there).

Trans # Type * *Date * * Num * *Name * *Memo * *Item * *Item Desc
413209 *Bill * *10/01/2011 100111 * * * Jones
* * * * * * * * * * * * * * * * Jones * Coffee
Account Qty * * Debit * Credit
A/P - Trade * * * * * * 210.02
Other * * * * * 210.02
* * * * * * * * 210.02 *210.02

Trans # Type * *Date * *Num * * Name * *Memo * *Item * *Item Desc
419986 *Payment 10/03/2011 12221 * * * *CC * * *Smith
* * * * * * * * * * * * * * * * Smith
Account Qty * * Debit * Credit
UndepFunds * * *682.11
A/R - Trade * * * * * * *682.11
* * * * * * * * 682.11 *682.11

Trans # Type * *Date * *Num * * Name * *Memo * *Item * *Item Desc
486672 *Invoice 10/22/2011 202513 * * * Grady
* * * * * * * * * * * * * * * * Grady * Unit 1 *West 11 descr West
* * * * * * * * * * * * * * * * West * *Non-Tax Non-Tax
Account * * *Qty * * * *Debit * Credit
A/R - Trade * * 275.00
South 2 * *-5.00 * * * * * * * *275.00
Sales Tax Pay * 0.00
* * * * * * * * 275.00 *275.00

Thanks -
Sara

So that I don't have to re-create your data for testing, send me a
file with an explanatiion to dguillett1
@gmail.com