Recent content by pcbozz

I must say that the value for "Numerodedocumento" is correct and it exist in PaylinkGP_VOI table.

Thanks a lot, that makes sense... I changed my code to this: strSQL = "Select * from PaylinkGP_VOI where TransactionReference =" & Numerodedocumento Set rsPaylinkGP_VOI = CurrentDb.OpenRecordset(strSQL, dbOpenSnapshot) _____________________________________________________ but it sends this...

All VOI lines are printed for each PAY line.. This is the result: PAY5900500564016100614071PAY00012113 00000444ANEGON001 USDANEGON001 000000000300000 0101ANEL GONZALEZ AIZPURUA VOI5900500564016PAY00022339 000000010001 VOI5900500564016PAY00022340 000000010001 VOI5900500564016PAY00022341...

Exactly,... I now what to do, but I need help with how to do it... can you help me with the code, I was thinking in a For... then statement with 2 cycles, but how can I code this?

OK.. This is the problem, the first query show the Customer data (7 columns), the second query shows the total ammount he buyed (3 columns) so the file should be like this: Customer1 data Customer1 ammount Customer2 data Customer2 ammount ...and so on Footer I need help with the "Customer"...

Hi, I need to export to a text file, something like this: Row1--Client A Details Row2--Client A Payments Totals Row3--Client B Details Row4--Client B Payments Totals ..... Footer - Sum of all payments I almost have it working but have problems wit the "body" (Row) of the file, how can...