Sum Values in Query by Date

L

Lloyd

I have a table where I am keeping track of caloric intake. I made a query to
summarize and I want to sum calories field by date. Get the total for each
date. The fields I have are: id(primary key), date, meal, food, calories,
notes.

Thanks in advance for your help.
 
A

Al Campagna

Lloyd,
If you really have a field in yoiur table called DATE, change that to something else,
like MealDate. "Date" is a reserved word in Access...

If you mean just the MealDate and the sum of calories for that day, a totals query with
these two fields would do it
MealDate Calories
GroupBy Sum

Would yield
1/1/07 1400
1/2/07 1145
1/3/07 1080 etc.....

--
hth
Al Campagna
Candia Computer Consulting
Microsoft Access MVP - Candia, NH USA
http://home.comcast.net/~cccsolutions

"Find a job that you love, and you'll never work a day in your life."
 
V

Van T. Dinh

Al

A bit optimistic with the calories?

We are lucky to keep our daily intake to less than 2500 even though we need
only about 1600, especially sitting in front of the computer all day like
us.

Congratulations on your award, Al.
 
A

Al Campagna

Van,
Ha! Right you are...
I should have suggested that Calories should be a numeric "Bite" field. Ouch!!! :-D
Thanks for the kind words...
--
hth
Al Campagna
Candia Computer Consulting
Microsoft Access MVP - Candia, NH USA
http://home.comcast.net/~cccsolutions

"Find a job that you love, and you'll never work a day in your life."
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top