Hello!.. I'm merging 2 query's invoice table andand payments table, my first problem is that when I do the left merge ( putting the payment into the invoices table) it's not putting the values where on the correct match so let say I have 5 invoices but only 1 of those should have a payment the merging is putting some other payments in the incorrect invoice.
Then I tried the merge the other way around, in the payments table using right merge with the invoices table and it actually puts in in the correct invoice..wow it matches! One I'll think!!! . I go to my visuals I do my 2 tables, one table contains the account number and it should tell me I have 1 invoice for that acc, and it does! But then if I drill to see those invoices, expecting it gives me the payment in the correct invoice number (like I have it on my original table) well it doesn't!!! It gives me the payment in another invoice :@. I have the connections made between INVOICE numbers in the two tables...
You think you can give a hand? I've tried everything!!! And nothing works 😞
Thanks!!
