473,320 Members | 1,572 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Average Problems

I am trying to get the average amount current, over30, over 60, etc..... for
my report. I have the total of the balance, total of Currnet, Over 30, etc.
but unable to get the Average percent of each that is currnet, over 30
,etc..... Since my sum field is unbound I can't run an avg([Total_Current]
\ [Total_Balance]). How can I get this to work?
Thanks,
Greg
Nov 12 '05 #1
2 2878
"Greg" <gk******@itlan.net> wrote in
news:IX*****************@nwrdny02.gnilink.net:
I am trying to get the average amount current, over30, over
60, etc..... for my report. I have the total of the balance,
total of Currnet, Over 30, etc. but unable to get the Average
percent of each that is currnet, over 30 ,etc..... Since my
sum field is unbound I can't run an avg([Total_Current] \
[Total_Balance]). How can I get this to work?
Thanks,
Greg


I don't know how your report is set up, but an average of your
[total_current] \ [total_balance] !should! be equal to the average
of [current]\[balance] for the same grouping of records.

Bob
Nov 12 '05 #2
Well after banging my head I think I found why it was not given me the right
results. I have been trying eveything but changing the "\" to "/" now it
work!!!! Thanks once again Bob for the help!!!! Hopefully somdeday I can
return the favor!!!
Greg
"Bob Quintal" <bq******@generation.net> wrote in message
news:94******************************@news.teranew s.com...
"Greg" <gk******@itlan.net> wrote in
news:IX*****************@nwrdny02.gnilink.net:
I am trying to get the average amount current, over30, over
60, etc..... for my report. I have the total of the balance,
total of Currnet, Over 30, etc. but unable to get the Average
percent of each that is currnet, over 30 ,etc..... Since my
sum field is unbound I can't run an avg([Total_Current] \
[Total_Balance]). How can I get this to work?
Thanks,
Greg


I don't know how your report is set up, but an average of your
[total_current] \ [total_balance] !should! be equal to the average
of [current]\[balance] for the same grouping of records.

Bob

Nov 12 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

6
by: J | last post by:
Kind of new at programming/vb.net. I'm doing this junky die roller program. Heres's what is supposed to happen: Roll 2 6-sided dies. Add rolls together put total in rolls(d6total). Display...
1
by: Alex | last post by:
I have a comma separated text file in the form: 11/28/2004 12:00:00, 2.78655354 11/28/2004 12:00:10, 1.9978 11/28/2004 12:00:20, 0.978 11/29/2004 12:00:00, 1.98467 11/29/2004 12:00:10, 3.005 ...
2
by: ashmangat | last post by:
I'm trying to claculate the average number of characters per words but having some problems Every time i run this program, i get 0 as the average #include <iostream> #include <string> #include...
4
by: Gary | last post by:
Hi, I have a temperature conversion program down pat, but I was told to add an average, meaning, i need to get the average temperature for as many times as it was entered. i do not know where to...
3
by: C++Geek | last post by:
I need to get this program to average the salaries. What am I doing wrong? //Program to read in employee data and calculate the average salaries of the emplyees.
1
by: Theadmin77 | last post by:
Well ...this is a real challenge .....i got everything else working OK...but ... I have to get the average and maximum value out of a group of people thru two functions .I have problems passing...
3
by: Salad | last post by:
http://www.mathwords.com/w/weighted_average.htm At the above link gives an example of a weighted average. It uses the following example: Grades are often computed using a weighted average....
10
by: mrooney | last post by:
Hi, I am having trouble getting Access to recognize two values as being equal to one another. Here's the situation (looks long but I am just trying to be uber-thorough): I have a large table...
13
by: vaneric | last post by:
hi i have a set of RGB images of diff faces (of people )as a 2 dim numpyarray ...something like threefaces=array(, , ]) where xa1,xa2,xa3 are tuples each representing rgb values of a pixel...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.