0

SQL

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

3rd Nov 2018, 6:10 PM
Isaac
Isaac - avatar
5 odpowiedzi
+ 7
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
3rd Nov 2018, 7:23 PM
Kuba Siekierzyński
Kuba Siekierzyński - avatar
+ 3
i solved it! thank you!
4th Nov 2018, 4:15 AM
Isaac
Isaac - avatar
+ 2
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.
4th Nov 2018, 4:12 AM
Janning⭐
Janning⭐ - avatar
+ 1
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
3rd Nov 2018, 6:55 PM
Isaac
Isaac - avatar
0
i tried that but it gives me an erroe
3rd Nov 2018, 11:23 PM
Isaac
Isaac - avatar