Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

forms calculation issue

Status
Not open for further replies.
wheels27

wheels27

MIS
Aug 26, 2002
30
US
i need to take the answer in =Sum([Cost])and devide it by
=Sum([Asset Count]) to get a average total


how do i do this, it will then creat a new toal answer
 
Sort by date Sort by votes
What are you trying to do? Do you have a bouond form? What sort of recordset?

rollie@bwsys.net

What id one mind reader say to another? You are fine! How am I?
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

kingz2000
  • Locked
  • Question
Bound/unbound forms
Replies
2
Views
635
dhookom
dhookom
hermanlaksko
  • Locked
  • Question
Ribbon screentip issue 1
Replies
13
Views
586
hermanlaksko
hermanlaksko
Freefall69
  • Locked
  • Question
Parse field and perform calculation 2
Replies
17
Views
582
Freefall69
Freefall69
InkyRich
  • Locked
  • Question
Basic help with Access forms
Replies
3
Views
300
InkyRich
InkyRich
StevenFromSouth
  • Locked
  • Question
Using .Fields() method in Recordsets for calculations. 1
Replies
1
Views
253
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top