Set rs = CurrentDb.OpenRecordset("S ELECT * FROM tblAgentCommissions2QuickB ooks") ![]() My guess is that it will need to loop within the 'do while' loop. I've attached the code to see if you can help me with writing the loop. My thought is that if I can put a loop in the makeiif file that will check for a negative amount and if it's a negative, it will change the transaction type from a BILL to a CREDIT. The ones that are negatives I believe have to be added as a 'credit' instead of a 'bill' (at least according to our accounting person). Some of the agent invoices are negative dollar amounts while most are positive numbers. I did do some more research and think I may have stumbled on the problem. ![]() ![]() They put me on another project and I just finished it. Hi irudyk, sorry for the delay in responding.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |