Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Query Problem

Status
Not open for further replies.
navdha88

navdha88

Programmer
May 1, 2003
8
0
0
CA
Hello all,

I had a sql query where i need to find the average of total counts. I do not have a field called average in any of the tables.

I joined 3 tables for the results. I import that to excel. Now I want to get a query for outstanding counts.

For example this is the table i imported to excel:

Code Countid tcount Average
3926 8 48 6
3939 6 54 9
(To find outstanding counts:)
which all codes have the
average >5. Please help. Is there any way i can use the table i import in excel for this purpose.


Thanks for the help.


Anu
 
Status
Not open for further replies.

Similar threads

TheresAlwaysAWay
  • Locked
  • Question
Delete query takes FOREVER to run 1
Replies
11
Views
99
jedraw
jedraw
LondonJohn
  • Locked
  • Question
Problem using Access 2003 and 2007 for the same database
Replies
4
Views
148
LondonJohn
LondonJohn
Moss100
  • Locked
  • Question
Create a Report from a query and then personalise the report for each client - possible?
Replies
2
Views
54
dhookom
dhookom
BradCustom
  • Locked
  • Question
Convert Access query to SQL query
Replies
5
Views
89
strongm
strongm
Bill6868
  • Locked
  • Question
Query Expression Question
Replies
3
Views
60
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top