•
•
•
•
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 403,494 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 4,285 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.
Please support our MS Access and FileMaker Pro advertiser: Programming Forums
Views: 4068 | Replies: 3
 |
•
•
Join Date: Mar 2007
Posts: 2
Reputation: 
Rep Power: 0
Solved Threads: 0
Newbie Poster
I can't figure out how to perform a calcuation in a query and have the result output for use in a chart within a report. Forgive me I'm a newbie
•
•
Join Date: Mar 2005
Posts: 65
Reputation:
Rep Power: 4
Solved Threads: 0
Junior Poster in Training
Okay, first things first. What type of calculation are you attempting to do in the query? Are you calculating across multiple fields? Please provide a little more information about the calculation and the table structure if any the calculated fields are based upon.
Chester
Chester
•
•
Join Date: Apr 2005
Location: Old Hampshire, Old England (LOL)
Posts: 11,937
Reputation:
Rep Power: 30
Solved Threads: 268
i just did this for my coursework
in the Field: section under the queries design view you can tyupe things like this.
GPPerCentre: [num_candidates]*[payment_eachscript]
(where gppercentre is what the field will be called, and num_candidates and payment_eachscript are existing firlds in the query)
in the Field: section under the queries design view you can tyupe things like this.
GPPerCentre: [num_candidates]*[payment_eachscript]
(where gppercentre is what the field will be called, and num_candidates and payment_eachscript are existing firlds in the query)
Last edited by jbennet : Mar 11th, 2007 at 6:14 pm.
TRY MY SUGGESTIONS AT YOUR OWN RISK!
james.bennet1@ntlworld.com
james.bennet1@ntlworld.com
•
•
Join Date: Mar 2005
Posts: 65
Reputation:
Rep Power: 4
Solved Threads: 0
Junior Poster in Training
You can also use queries to calculate fields from several tables, perform regular calculations, etc. You can also perform calculations inside a report based on grouping and that may be easier, but I need to know a little more about what the calculation is and the underlying table structure.
|
•
•
•
•
•
•
•
•
DaniWeb MS Access and FileMaker Pro Marketplace
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Linear Mode
- date comparison (JSP)
- Query multiple tables with duplicate data (MySQL)
- javascript code for performing calculation when all the columns have the same name (JavaScript / DHTML / AJAX)
- PHP Search pagination problem (PHP)
- JBuilder Gui textArea Help! (Java)
- The Calculator (C++)
Other Threads in the MS Access and FileMaker Pro Forum
- Previous Thread: Changing a default value on the fly
- Next Thread: [Stupidity] I Forgot My Ms. Access Database Password. Help..
