A
annysjunkmail
Hi,
I manage an awards database. Awards are paid in stages called payments,
which vary in amount. I have 2 main tables in my database called
tblAwards and tblPayments.
I am trying to produce a query to group Awards to show total payments
and, very importantly, to show balance remaining for each award. I can
show Awards and total payments but I can't work out how to show the
balance remaining in the same query - it has to be the same query.
Can it be done - it would be great it someone could help me here!
Thanks
Mick
I manage an awards database. Awards are paid in stages called payments,
which vary in amount. I have 2 main tables in my database called
tblAwards and tblPayments.
I am trying to produce a query to group Awards to show total payments
and, very importantly, to show balance remaining for each award. I can
show Awards and total payments but I can't work out how to show the
balance remaining in the same query - it has to be the same query.
Can it be done - it would be great it someone could help me here!
Thanks
Mick