How to count average based on criteria?

34 New Member

I have 3 tables and 1 query, please see image below.
So i want to build a report that show information about average score by student city:

Total Average = Avg([score])
Total Average Texas City only = ????
Total Average Washington City only = ?????

Please help me

Attached Images

average.jpg (36.9 KB, 1046 views)

Oct 1 '12 #1

Subscribe Reply

3086

Rabbit

12,516

Recognized Expert Moderator MVP

You can use the DAvg function for the city breakdown if there's not too many. Otherwise. I would just do it as a subquery with a record source that returns the average by city.

Oct 1 '12 #2

yosiro

New Member

sorry,can you write that function like

Expand|Select|Wrap|Line Numbers

=DAvg([score]..........??

because am too newbie for programming :(

Oct 1 '12 #3

zmbd

5,501

Recognized Expert Moderator Expert

yosiro,
Google the DAvg() function or press [F1] for the context help in Access.

Also, what have you tried? I see a homework question without any effort made to solve the question.

We can help solve specfic errors and climb tall mountains; however, you have to get the rope up the side of the mountain just a little bit.

Oct 1 '12 #4

yosiro

New Member

After some experiment i am succeed find that formula, thanks master zmbd

Expand|Select|Wrap|Line Numbers

Epr = DAvg("[score]","Query_Student","[city]='Texas'")

Oct 1 '12 #5

Similar topics

22082

how to count words from text

by: dan | last post by:

this is a program to count average letters per word. i am able to count the total number of letters, but not words. How do you count the total number of words in a text file, so i am able to divide...

C / C++

44318

How To Do An Average Of A Count

by: Mike Bannon | last post by:

Hi All We have an order processing database which includes the standard Order Header/Order Lines tables. I'm trying to write a query to get the average number of lines per order over a given...

Microsoft SQL Server

1413

date based criteria

by: C White | last post by:

got another one for you guys out there, and thanks again for the help with my "counting question" this time i'm looking to select records based on date, the database stores the date as...

ASP / Active Server Pages

4490

duplicate records - based on different fields

by: Rado | last post by:

Hi All, This might quite simple process for some but I am finding it really difficult to do. What is required is not a standard Duplicate query but a variation on it. For example I have...

Microsoft Access / VBA

12425

Select Count(*) problem

by: MP | last post by:

vb6,ado,mdb,win2k i pass the sql string to the .Execute method on the open connection to Table_Name(const) db table fwiw (the connection opened via class wrapper:) msConnString = "Data Source="...

Microsoft Access / VBA

4321

Running count in Access query

by: loki419 | last post by:

I have a simple select query that produces results similar to this LOCATION FUNCTION 001 1111 001 1111 100 1111 100 ...

Microsoft Access / VBA

2190

Query Count Function

by: Starke | last post by:

I have a table where Im counting records that have a two certain criteria. My Question is, If one criteria is met, but the other isnt instead of not retrieving the record can the count value...

Microsoft Access / VBA

1334

AVERAGE from file pls help

by: thankamani | last post by:

HI all Am a newbie in C. I am trying to calculate the average of some numbers (floating point) from a file : the file format is as follows 0 3.312000 3.312000 3.312000 1 3.362000 ...

C / C++

8216

PERL script that prints out the file names and file sizes and determines the average

by: Ormazd | last post by:

Hello, I was wondering if anyone might be able to help me with a little PERL script? I'm very new and I have been given a task to write a simple Perl script that prints out the file names and...

Perl

13605

How to get count of multiple criteria

by: yappy77 | last post by:

I have a database where all companies must meet 3 requirements in order to be in compliance. I need to know out of the total number of companies that are not in compliance how many do not meet...

Microsoft Access / VBA

7223

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

7115

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

7321

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

7377

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

7036

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

Windows Server

5047

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 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 a new...

Microsoft Access / VBA

3191

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...

Networking - Hardware / Configuration

3179

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

762

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP