0

Okay here's where I am at currently...

RELATIONSHIP:
Personal Profile ---One-to-Many--> Receipt Totals ------> Service Performed

The personal profile & receipt totals are connected via Customer ID while the Receipt totals and the Service Performed are connected via Receipt ID

I have them all together and they work just fine. I had it set up like this so that I could add in as many services to that one receipt as needed (anywhere from 1 - 10 items could have been chosen for just one receipt)

Now under receipt I have 4 items...
-ID
-Receipt ID
-Total Cost
-Customer ID

And my Service Performed:
-ID
-Receipt ID
-Service Performed
-Cost


I want to be able to add up the costs for each receipt (note: cost is under service performed), and place the value in "Total Cost" I thought a Sum function could do this but it gives me an #error message.

Here's my current expression attempt in the form (this is placed in the Total Cost):

=Sum([Service Performed subform].Form!Cost+[Service Performed subform].Form!Cost)

Maybe you guys have ideas? If you need more info, please let me know!

Thanks a ton and I appreciate it!!
--Mike

2
Contributors
1
Reply
2
Views
11 Years
Discussion Span
Last Post by Edward Kinlen
This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.