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 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
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 This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
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...
|
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
...
|
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...
|
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...
|
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.
|
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...
|
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....
|
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...
|
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...
|
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...
|
by: ryjfgjl |
last post by:
ExcelToDatabase: batch import excel into database automatically...
|
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...
|
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)...
|
by: Defcon1945 |
last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
|
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....
|
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
|
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...
|
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...
| |