I need help with this. I have a customer check and I need to run a query that will bring back the customers orders that will tie to this check. For example: the customer has 6 orders like this;
order# $amount
1234 100.00
1235 250.00
1265 100.00
1239 250.00
1269 100.00
1278 400.00
Now the customer pays us with a check of 1000.00. The query should bring back the orders that total the check amount and if the check amount does not equal the orders exactly then it should take the next order in the line and bring back the sum of the difference. In this case it would bring back something like this
1234 100.00
1235 250.00
1265 100.00
1239 250.00
1269 100.00 and
1278 200.00 for the remaining amount.
How do I do this and on what object would I place the code (form,query or report).
I hope this helps in answering this question. Thanks in advance for the help. Also if this can't be done in access please let me know so I will stop trying. Thanks again.
RBE
order# $amount
1234 100.00
1235 250.00
1265 100.00
1239 250.00
1269 100.00
1278 400.00
Now the customer pays us with a check of 1000.00. The query should bring back the orders that total the check amount and if the check amount does not equal the orders exactly then it should take the next order in the line and bring back the sum of the difference. In this case it would bring back something like this
1234 100.00
1235 250.00
1265 100.00
1239 250.00
1269 100.00 and
1278 200.00 for the remaining amount.
How do I do this and on what object would I place the code (form,query or report).
I hope this helps in answering this question. Thanks in advance for the help. Also if this can't be done in access please let me know so I will stop trying. Thanks again.
RBE
