AVG newbie

  • Thread starter Thread starter Flemming
  • Start date Start date
F

Flemming

Hi

Thank you for using time on my issue.

Year Round PlayerID Total Points Par3
Par4 Par5
(1-6 pr year)


I need two queries to return


Year PlayerID AVG Total AVG Points AVG Par3 AVG Par4 AVG
Par5


Round PlayerID AVG Total AVG Points AVG Par3 AVG Par4 AVG
Par5


Thanks a lot
Flemming
 
What? No par 6's!

Insert the proper table name.

SELECT tblPuttPutt.[YEAR],
tblPuttPutt.PlayerID,
Avg(tblPuttPutt.[Total]) AS AVG_Total,
Avg(tblPuttPutt.Points) AS AVG_Points,
Avg(tblPuttPutt.Par3) AS Avg_Par3,
Avg(tblPuttPutt.Par4) AS Avg_Par4,
Avg(tblPuttPutt.Par5) AS Avg_Par5
FROM tblPuttPutt
GROUP BY tblPuttPutt.[Year],
tblPuttPutt.PlayerID ;

SELECT tblPuttPutt.[Round],
tblPuttPutt.PlayerID,
Avg(tblPuttPutt.[Total]) AS AVG_Total,
Avg(tblPuttPutt.Points) AS AVG_Points,
Avg(tblPuttPutt.Par3) AS Avg_Par3,
Avg(tblPuttPutt.Par4) AS Avg_Par4,
Avg(tblPuttPutt.Par5) AS Avg_Par5
FROM tblPuttPutt
GROUP BY tblPuttPutt.[Round],
tblPuttPutt.PlayerID ;

Year is a reserved word and I think Round and Total may be also. Therefore
the [] brackets surrounding them. You should try to avoid all the reserved
words in field, table, and other object names. Check out the following:

http://support.microsoft.com/kb/286335/
 
Thanks Jerry - my own errors are displayed fine by your well working
examples.

Thanks,
Flemming


Jerry Whittle said:
What? No par 6's!

Insert the proper table name.

SELECT tblPuttPutt.[YEAR],
tblPuttPutt.PlayerID,
Avg(tblPuttPutt.[Total]) AS AVG_Total,
Avg(tblPuttPutt.Points) AS AVG_Points,
Avg(tblPuttPutt.Par3) AS Avg_Par3,
Avg(tblPuttPutt.Par4) AS Avg_Par4,
Avg(tblPuttPutt.Par5) AS Avg_Par5
FROM tblPuttPutt
GROUP BY tblPuttPutt.[Year],
tblPuttPutt.PlayerID ;

SELECT tblPuttPutt.[Round],
tblPuttPutt.PlayerID,
Avg(tblPuttPutt.[Total]) AS AVG_Total,
Avg(tblPuttPutt.Points) AS AVG_Points,
Avg(tblPuttPutt.Par3) AS Avg_Par3,
Avg(tblPuttPutt.Par4) AS Avg_Par4,
Avg(tblPuttPutt.Par5) AS Avg_Par5
FROM tblPuttPutt
GROUP BY tblPuttPutt.[Round],
tblPuttPutt.PlayerID ;

Year is a reserved word and I think Round and Total may be also. Therefore
the [] brackets surrounding them. You should try to avoid all the reserved
words in field, table, and other object names. Check out the following:

http://support.microsoft.com/kb/286335/
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

Flemming said:
Hi

Thank you for using time on my issue.

Year Round PlayerID Total Points Par3
Par4 Par5
(1-6 pr year)

I need two queries to return

Year PlayerID AVG Total AVG Points AVG Par3 AVG Par4
AVG
Par5

Round PlayerID AVG Total AVG Points AVG Par3 AVG Par4
AVG
Par5

Thanks a lot
Flemming
Click to expand...
Click to expand...
 
Back
Top