UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

> I need to calculate the ratio of two queries    
 
   
runawayfromacces...
post Feb 24 2007, 10:18 PM
Post #1

New Member
Posts: 4



Hi,

I have two queries in which I calculated expected and actual sales. I have to first calculate the sum of the expected and then of the actual sales column and then divide them to get a ratio so that I can present them in report form.

How should I proceed?

Thanks
Go to the top of the page
 
+
 
Start new topic
Replies
KenSnell
post Feb 24 2007, 10:57 PM
Post #2

UtterAccess VIP
Posts: 1,117
From: Michigan, USA



Why not just do the calculation in the report itself?
Go to the top of the page
 
+

Posts in this topic


Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 



RSS Search  ·  Go to Top  ·  Lo-Fi Version Time is now: 17th April 2014 - 04:34 AM