Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
patrickh
Starting Member
2 Posts |
 Posted - 2002-03-01 : 13:43:39
|
| Hi, I'm very new to SQL so please excuse my ignorance on this subject. I am using Access 2000 and have a simple query using the SELECT LIKE function, and what I would like to do is also add the AVG function to display the average of a column from the results of the query, appending the average to the bottom of the query result (not actually adding it to the table).Is this something possible to do, or is this something I should try to achieve via Reports? Any help would be really appreciated, thanks alot.-Patrick |
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2002-03-01 : 14:41:41
|
| If I understand correctly, you want to display a column of numbers, and then an average of that column below it. That is something you can do easier in an Access report than in a SQL Query. If you just wanted averages, that's an easy query, but to get the display like it sounds you are looking for, look into reports, footers sections.------------------------GENERAL-ly speaking... |
 |
|
|
|
|
|
Appending AVG to a query?