Hi everyone
I have a invoice form that I enter the summary of cost and the item category that is spent for and also the date of the invoice.
I want to calculate that in each date and for which category how much money spend?
at first I wanted to do this through query but the there are multiple situation that may be occur.
I don't know, how is it possible?!
this is my invoice structure:
InvoiceNo
InvoiceDate
Customer
ServiceCategory ("Service";"Stuff";"Both Option")
Cost
Is there anybody help me on this case?
thanks in advance
Marziya
I have a invoice form that I enter the summary of cost and the item category that is spent for and also the date of the invoice.
I want to calculate that in each date and for which category how much money spend?
at first I wanted to do this through query but the there are multiple situation that may be occur.
I don't know, how is it possible?!
this is my invoice structure:
InvoiceNo
InvoiceDate
Customer
ServiceCategory ("Service";"Stuff";"Both Option")
Cost
Is there anybody help me on this case?
thanks in advance
Marziya
Last edited: