Ok, here is the deal.
I have a large spreadsheet that contains 1 row for charge, 1 row for insurance payment and 1 row for patient payment.
I have imported into access.
I want to have 1 row of data for this patient with the charge amt, insur payment amt and for the patient payment.
I created a query and have been playing around in there but can't seem to get it to work.
Now, a patient can pay more so I might have more rows than just the 3 mentioned above or there could just be a charge.
How can I get one row based of account number with all the fields popluated??