Microsoft Access subforms

•

What is DaniWeb IT Discussion Community?

You're currently browsing the MS Access and FileMaker Pro section within the Web Development category of DaniWeb, a massive community of 426,528 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 1,823 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.

Join our community!

Please support our MS Access and FileMaker Pro advertiser: Programming Forums

Thread Tools Display Modes

Views: 4137 | Replies: 1

•

Join Date: Dec 2005

Posts: 1

Reputation: mxcsquared is an unknown quantity at this point

Rep Power: 0

Solved Threads: 0

mxcsquared mxcsquared is offline

Offline

Newbie Poster

Microsoft Access subforms

Dec 14th, 2005

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):

•