sum problem

[kathyc20]

I have a table with the fields month which contains every month of the year and a field called personal_month which contains numeric values.

I need to write a query for my form that gives me the sum of all the personal_month records from the kms_table where month=January

example:

=Sum(kms_table.Personal_Month FROM kms_table WHERE(((kms_table.Month)='January')))

This query doesn't work

 

[PaulBricker]

Your expression isn't a query. There is no Select keyword.

Select Sum(Personal_Month)As SumOfPersonal_Month
From kms_table
Where [month] = "January";

Paul

 

[dhookom]

Kathyc20,
Please don't ask the exact same question in more than one forum. You have at least two threads going now on the same question.

Tell us which threads to stop replying to and direct us to the proper forum.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]