Percent....Question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Kindly help me on this issue...

i have a result from query like this

year totals
2005 34000
2006 68000

i have to display increase(in percentage)
like this

year totals
2005 34000 0 %
2006 68000 50%


i have formula for percentage..but i dont have two diferent fields...
i have two values in the same field or same column....Please help me
in this issue.
Thanks in advance.
 
also this is sum query...i get totals from table..ie the full year sales...

also i may have in future..like this
year station Totals
2005 a 33
2006 b 55
2007 c 65


thanks in advance
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Curve fitting with weighted trendline 1
SQL Server Question 2
Access Test if value is less than percent 0
summing based on multiple array criteria 3
Showig differences in Month to Month data from data in the same ta 8
New column on report 6
Calculated Fields on a Report giving me "#error" 2
simple macro to compare lists 1

Back
Top