Steve,
Let's see if I can do this better than before.
I have 22 products that I track quantites built and defects for each product. So I have a report that has 22 rows (one for each product) and about 30 columns (one for each quantity or defect associated with the product). Kinda looks like this:
Product Qty Built Defect 1 Defect 2 Defect 3 Defect 4; etc
Product1 100 1 2 3 1
Product2 10 0 1 4 2
Product3 121 4 0 5 2
etc
I have a report that shows all of this and works very well. What I need to be able to do is show this report for time periods. For instance the month of October. When I do this, because there are multiple entries for each day, my report then has a row for each entry so instead of having a report showing 22 products, one row for each product, I have a report that might have a hundred rows, one for each entry. Product1 for instance may have 5 separate entries. Actually I don't need to show the time period on the report I just need to be able to show the data from specific time periods.
Does this explain it any better?
Hope so,
Thanks for your interest,
Don........



"SteveS" sanfu at techie dot com wrote in message ...
Don,

I'm still not sure I understand what you are trying to do. Would you give
some sample data? So far I know you have 22 products and 30 columns but what
does the report look like?

Product Qty
Widget1 40
Widget2 10
Digit1 15
Digit2 50
Gidget1 33
.
.
.
Item22 13


Are there more columns in the report? I know you want the month/year in
there somewhere.

What version of access are you using? If you want to send me a cut down
version (maybe 500 lines in the table), I have A2K (or A97 is ok). See my
email below.

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.

Grouping is like having unlimited sub reports. Grouping adds more sections
to the report. You can sort within the grouping and each group has its own
header and footer. In the group header you can put the field that you are
grouping by and remove it from the Detail section.

Say you have a report that has two sub-reports: This month and last month.
Now your boss wants to see this all of this years data by month. You could
try and add 10 more sub-reports......well you could try. :0

Or you could get rid of the sub-reports and use grouping. You might have to
change the record source a little to get the month/year into separate fields
(in the query). Add a group section (header) for the month, put the month
field in the group header and the rest of the fields you want to se in the
detail section. Set the sorting (if you want) and your report is done!

If you wanted to see 5 years of data by year-month, the grouping would be 1)
Year field and 2) Month field. Put the year field in the first group header
and the month in the second group header. The Detail section gets the rest of
the fields you need in the report.

Try it on a *copy* of a report......


Steve
--------------------------------
"Veni, Vidi, Velcro"
(I came; I saw; I stuck around.)

sanfu at techie dot com replace the at and dot with the symbols & no spaces


"Don Sealer" wrote:

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........