Still Hoping for help with a Query problem

Anyone interested in helping please let me know. I did get a reply (below)
but unfortunately I don't understand it.
Still looking,
And thanks to all,
Don...........

Brett,
I'm not sure how to reply to your instructions. I replied to your post but
it came back as underliverable.
Here's my questions

Actually I meant 22 products but you're exactly right, one line for each
product and the qty for it. I already have a report that shows this data
but it doesn't include the date. So I've got a report that shows each
product on it's own line and shows the total quantities for each. Now I'd
like to be able to show this data in time periods.
I don't understand a whole lot of this. There are many features I've never
used in Access. I'd like to break this down one or two questions at a time
if you don't mind.
Questions:
You say "make sure you have Sorting & Grouping by Product in your report.
I'm not sure what you mean nor do I know how to do that. I can find Sorting
& Grouping on the View menu but I'm not sure how to use it or what you want
me to do with it.

Let's start with that. You're right , I do have lots of questions.
Thanks for your help,
Don........

Brett Collings [429338]" wrote in message
. ..
Don, where you say you want to "group" all 162 entries into just the 2
products, I think what you mean is that you want just one line for
each product and the Sum() of the Quantities and Defects. Is this
correct?

If it is, here is a quick suggestion. Make a copy og that Report so
that as we play with it, it doesn't matter if we break it. Once you
have that feeling of freedom, you'll be a little more adventurous.

- Make sure you have Sorting & Grouping by Product in your report
- open Group headers and footers (Menu-View-Grou....)
- put your controls in the detail section of the group band
- Name each control correctly with a simple Naming Convention prefix
like txt, num, dte, cbo (Report Design-Properties-Other-Name). The
Name of a control MUST be different from the ControlSource.
- in the Group footer add a new text box for each of the fields that
you want to total and make their controlSource things like
Sum(numDefects) or Count(txtDefects). Note that we are using the NAME
of the control in the detail band and NOT it's ControlSource.
- at this point I go to the trouble on NAMING each of these
calculation controls with the prefix "cal" and a descriptive name for
it. Once you get into code behind the form, unclear naming like
"Text442" really kills you.
- click the Details bar, go to it's Properties and mark it invisible

Preview the report and all you will see are the totals! The trick is
that the detail band information (the 162 records) must be there,
you've just made them invisible. Because you have set a grouping for
Product, you will get 22 bands displaying totals. Piece of cake huh


That's a quick and dirty ... there'll be a lot of tidying up and
you'll have more questions ... ask away

Brett