Advertisement

There's no such thing as a stupid question, but they're the easiest to answer.
Login
Search

Advertisement

Business Applications Business Applications
Search Search
Search for:
Tech Support Guy > > >

Access 2010 - - - Auto Calculate Totals


(!)

luvs_kaos's Avatar
luvs_kaos luvs_kaos is offline
Member with 42 posts.
THREAD STARTER
 
Join Date: Aug 2007
Location: NYC
Experience: Intermediate
03-Apr-2012, 06:59 PM #1
Unhappy Access 2010 - - - Auto Calculate Totals
So I have created a from in Access to work as a data base and as a Receipt to give out.

Now I have about 17 fields that I need to be calculated.

Prior to this, I have been doing this in excel and then copy and paste into Access, this is kind of a pain to keep two separate files and to update two separate files

One field I need is "TOTAL PAID"
My form follows a format as follows

ITEMS Producer FEE Our FEE
Item 1 $00.00 $00.00
Item 2 $00.00 $00.00
Item 3 $00.00 $00.00
Item 4 $00.00 $00.00 (I have seven "items" that need to be listed)
TOTAL $00.00 $00.00 (I want this to auto calculate the "Producer FEES" / And "OUR FEES"

Then I need a calculation of the grand total of "Total Producer fees" and "Total Our fees"

I am trying to be clear is possible... I hope that there is someone out there that can help me with this....
Rockn's Avatar
Computer Specs
Member with 21,189 posts.
 
Join Date: Jul 2001
Location: Somalia of the North, MN
Experience: Disenfranchised American
03-Apr-2012, 08:42 PM #2
Use a report to calculate the totals
OBP's Avatar
OBP OBP is offline OBP is a Trusted Advisor with special permissions.
Computer Specs
Trusted Advisor with 18,441 posts.
 
Join Date: Mar 2005
Location: UK
04-Apr-2012, 06:09 AM #3
I am concerned about your data structure that you have 17 Fields, rather than 17 Records.
If you had 17 Records you could just total the records in the form's Footer.
luvs_kaos's Avatar
luvs_kaos luvs_kaos is offline
Member with 42 posts.
THREAD STARTER
 
Join Date: Aug 2007
Location: NYC
Experience: Intermediate
04-Apr-2012, 11:00 AM #4
My goal is essentially to create a database that will keep records and primarily act as a receipt book.

Below is a rough layout of what i need.

so all of the items in the first circle need to be totaled at the bottom, and as well for the second column...

then those two totals need to be combined towards the top of the page.



So when I enter the fees i want it to auto calculate the totals, and ultimately print that record out as a customer receipt... and still maintain it as a searchable document.

is this even possible?
i didn't really want to create a report every time i need a receipt.

(I am a beginner at access...clearly...)
OBP's Avatar
OBP OBP is offline OBP is a Trusted Advisor with special permissions.
Computer Specs
Trusted Advisor with 18,441 posts.
 
Join Date: Mar 2005
Location: UK
04-Apr-2012, 11:07 AM #5
The standard way to do what you want is to have at least 2 tables, one for the top section of data ie the Receipt and the second for the items of the receipt.
The second table is then used as a "Subform" for data entry & display. The subform can then do the calculation and the "result" placed in the "sum of" field.

Of course to Print the data you should use a Report.
__________________
OBP
I do not give up easily
As Seen On

BBC, Reader's Digest, PC Magazine, Today Show, Money Magazine
WELCOME TO TECH SUPPORT GUY!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.


Tags
access, access 2010, help me

(clock)
THIS THREAD HAS EXPIRED.
Are you having the same problem? We have volunteers ready to answer your question, but first you'll have to join for free. Need help getting started? Check out our Welcome Guide.

Search Tech Support Guy

Find the solution to your
computer problem!




Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools


WELCOME
You Are Using: Server ID
Trusted Website Back to the Top ↑