Sum by date keep data

[ashbear]

I have the following four fields



Name SS# Date $

The date is the repeating field I need to sum on. I want to keep name and SS# but have it summed by date. Can you do it in QBE or do I need some special SQL??

Thanks all

[jzwp11]

Welcome to the forum!

First off, name and date are reserved words in Access so they should not be used as table or field names. Also, it is not a good idea to have spaces or special characters (#, $) in your table or field names.

The date is the repeating field I need to sum on.

I'm confused by the above, do you want to sum the date field
or do you want to sum the currency field (that you designate with a $) by date within person/SSNNo?

You should be able to use the query design grid for most queries with the exception of UNION queries.

Could you provide some example raw data and what you expect the final output to look like?

[ashbear]

Actually the fileld names are just examples not the real names. Anyway thanks for the info. I'll give it a try...