UtterAccess.com
We have detected that you are using an unsupported web browser. We recommend you to upgrade your web browser to get the most from UtterAccess forums.
Why should and how can I upgrade?
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,
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: 23rd August 2014 - 02:29 AM