SQL

Question

Anybody could help me with a problem I have with SQL on Access

Answer 1

I haven't been using Access for soooo... long but if you can use pure SQL there, try something like:

SELECT State, AVG(Snowfall)
FROM TableName
GROUP BY State

Answer 2

i solved it! thank you!

Answer 3

Then you'll have to be more specific. 😉 Analogy: A mechanic can only give you a certain quality of advice that may or may not solve your problem if you don't bring the actual car for him/her to look at.

Answer 4

it’s very simple actually, i have a table with 3 columns state, city and snowfall. the state has some value that repeats for example California will have 2 cities so California will be repeated on the table but not the cities. i just want to the avg snowfall for each state

Answer 5

i tried that but it gives me an erroe