I need to create a query that will give me averages on a list of numbers. How can I calculate the averages, but ignore 0 or null values. Addtionally if I am...

I have a simple table consisting of 13 columns. The first col is the location and the next 12 are the scores received in each of 12 months, some months have...

Okay, I have -=cycletime. In a query how can I have a field that reports the total average of all the records for the cycletime? So say I have 50 records I...

Is there a way to average the values of field within a query? I have a query that determines the total minutes a task takes to complete, this field is label...

Hello, I posted (creating relationships with time series) yesterday within "access Database Design". Basically I have 24 tables that are linked to txt files...

Hi, i'm trying to produce a graph with a data point which is the average for each weeks worth of data. The date field is called Job Date However I want the...

Hello there, i have a form with a query that calculates the average processing time for a event and it works fine when there's been more than one entry. I...

Hello: I would like a query to determine the average time between events. For example, given the following records: TimeColumn 8/5/2006 12:15:35...

I have a opened Date and a closed date and I would like to find out the average time is took to open and close a certain record based on a Area. SELECT...

I have a column that is in general date format, 6/19/2007 5:34:23 PM. In another column I have a value between 10 and around 50. What I have to do is get the...

Need to find out the average number of days between the date and the ship date. This needs to be shown line by line for a future report. I am new to access...

Need To Know the name of the Fuction( if exist) that give me the Avarege of the Values 0 . ("True Average") Thank u

Hi Group. I'm sure this should be straight forward, but I just can't get my head round the most efficient way to do it... I have 2 tables. PARTS(14,000...

Hi all. I am trying to average the total records by date range. I am getting an error message with my AVG expression. Here is a snap shot of the SQL I have...

Why does this happen?

I am trying to get the average retail price in a query from a table that has the same item listed 3 or 4 times but sold to different customers. The end...

I am developing an attendace tracking system which accepts numerical values instead of options like Present: Yes/No. now, I want to compute the average of the...

I am importing a table and I am trying to query the average price for an item, the issue is the items have been sold to a variety of customers and at various...

Hi Everyone, Using Access 2003 and I use the query grid but post the sql so it helps you guys. I have an audits database that we use to keep track of how...

Excel has a "Harmonic Mean" calculation that I need to use in an Access query. Is that possible? Formula in Excel is: =HARMEAN(R2:R28) I would like to apply...