Sum fields

[Diedrik]

Hi All

I need some help.
I have a table with 2 fields (Nights and year) that looks like this:
Nights, Year
1, 2004
2, 2004
44, 2005
45, 2005

Now I want to make an sql query that returns a sum of each year like this:

field 2004,2005
Data 3, 89

How can I make this work?

Sincerely
Diedrik

[rod]

Try the "Group by" clause and use the "SUM" operator.

eg.

Select Sum(Nights) as TotalNights, Year

From Table1

Group By Year

Hope this helps.