Totals Query - Microsoft Access Forum - Computer Learning Zone


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Totals Query

Larry Fisackerly

14 months ago

I want this Totals Query to show the total amount I spend at the grocery store (HEB or H-E-B) each month during the year. Instead of showing the totals for each month, it is showing the individual purchases during each month. It does not total the monthly purchases. How do I fix this?

	Larry Fisackerly OP @Reply 14 months ago

	Larry Fisackerly OP @Reply 14 months ago

	Kevin Robertson @Reply 14 months ago
You will need to remove the Description field as each of those values are different (you can't group on them).

	Larry Fisackerly OP @Reply 14 months ago
Brilliant observation. One sentence solution! Thank you so much for solving my problem.

	Larry Fisackerly OP @Reply 14 months ago
Kevin, I am trying to send an Amazon UK gift card from USA. It needs your email. Can you share that?

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View