 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Queries / November 2005created fields then used as criteria in another field in same quer
I have a query in which I included a sum of two fields and called it "Total" I then wish to take the field "Total" and and divide it by another field to get a percentage. When I run the query it brings the created filed up like a parameter what do i do to prevent this from happening??? > I have a query in which I included a sum of two fields and called it > "Total" I then wish to take the field "Total" and and divide it by > another field to get a percentage. When I run the query it brings the > created filed up like a parameter what do i do to prevent this from > happening??? You normally can't use the alias of a calculated field as if it were a "real" field in other calculations of the same query. You have to repeat the first calculation within the second one. Instead of... Percnt: [Total]/[SomeField] ...use... Percnt: ([Field1] + [Field2])/[SomeField]  SignatureI don't check the Email account attached to this message. Send instead to... RBrandt at Hunter dot com |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.