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

Solved: Access 2007 Query : Calc based on Sum


(!)

DigitalMedic's Avatar
DigitalMedic DigitalMedic is offline
Member with 2 posts.
THREAD STARTER
 
Join Date: Feb 2012
Location: Horsham, West Sussex. England
Experience: Advanced
16-Feb-2012, 09:18 AM #1
Solved: Access 2007 Query : Calc based on Sum
Hi all,

I've been struggling with this for a while, so I hope someone can help.

I'm using Access 2007 and have am using a TOTALS query which has a column that returns the SUM of HoursWorked

My problem is that I want to add a column which calculates two columns in this query and gives me the result of Total_Invoice: Rate * HoursWorked

Obviously I need the SUMMED value of hours worked in this calculation.

Is this possible?

Note:
I've tried changing it to a MAKE TABLE query and trying to do this calculation in an update query, but I can't get an update query to update the Total_Invoice column based on Rate * HoursWorked

Any and all help greatly appreciated.

Rob

Last edited by DigitalMedic; 16-Feb-2012 at 09:22 AM.. Reason: Quoted the wrong Field!
DigitalMedic's Avatar
DigitalMedic DigitalMedic is offline
Member with 2 posts.
THREAD STARTER
 
Join Date: Feb 2012
Location: Horsham, West Sussex. England
Experience: Advanced
16-Feb-2012, 09:47 AM #2
Changed the query to a Select query (as it was a Make Table query).
Then ran another query based on the first one and was able to perform the required calculations that way.

If it is possible to do it within a single query I'd be happy to know how!

Rob
OBP's Avatar
OBP OBP is offline OBP is a Trusted Advisor with special permissions.
Computer Specs
Trusted Advisor with 18,566 posts.
 
Join Date: Mar 2005
Location: UK
16-Feb-2012, 10:19 AM #3
It is possible to have a "query within a query", ie nested queries. The "inner" query is run first and then the outer query.
You can also use "Join" queries as well.
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
2007, access, calculation, formula, query

(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 ↑