Problem with SQL langauge using sum,amx

[Nader]

I have DBaccess with these 7 columns B, C, D, E, F, G, H … Column F including Numbers.

I want to creat this SQL syntax;

" SELECT B,C,D,E, sum(F) , max(G) ,max(H) From Table1"

But it didn't succees with me.

 

[MattP]

The error messages telling you that B, C, D, & E are invalid because they're not in an aggregate function and there is no GROUP BY clause didn't give you a place to start?

Start your reading here: SQL GROUP BY Statement

 

[Nader]

It is a very useful site
Thank you very mush!

 

[cjard]

Please stop psoting these questions in Data Access. These are SQL Language specific questions and they have their own special forums. By posting here you are not only posting off-topic threads, but you are not reaching the relevant experts. Post in the forum dedicated to the database youre using. For a list, see here:
Database - Visual Basic .NET Forums

 

[Nader]

OKy!. Thank you for Clarification