L
Lori
Okay, here's what I need help with. I'm trying to create an invoice online
that will keep a running total of "Previous Billed". I have set up two
tables, one to keep track of the invoice specifics and one for the details.
The details includes what is being billed, contract value and amount, along
with a invoice number which links the two tables together.
Now here is the question, how do I run a query on invoice # 2 which will let
me use the information for Invoice # 1 in the Previous Billed column? Can
this expression be written? I'm stumped.
Any help appreciated.
that will keep a running total of "Previous Billed". I have set up two
tables, one to keep track of the invoice specifics and one for the details.
The details includes what is being billed, contract value and amount, along
with a invoice number which links the two tables together.
Now here is the question, how do I run a query on invoice # 2 which will let
me use the information for Invoice # 1 in the Previous Billed column? Can
this expression be written? I'm stumped.
Any help appreciated.