D
dsealer
Guest
I have a database with a table that collects data as I enter it from a form. I have a couple of queries that sort the data into two different reports. Here's some of what I'm doing. I'm collecting data associated to products. I have about 22 products and about 30 columns tracking problems with these products. I am counting the problems and sending them to the two different reports. Over the course or time I've collected about 2000 records associated with these products, this number will continue to grow as I enter daily data. In order to count all of these problems I've used "Sum" and different "expressions" to arrive at total counts for the problems. Everything works well. When I look at my report it shows the 22 different products and totals for all the defects associated with these products. Here's where I'm stuck.
I want to be able to query this data according to date, from the beginning of one month to the end of that month for example. The problem is when I do this my report shows every record for that time period, which may be a couple of hundred. I'm still looking for only the totals for each of the 22 products. Is there a way I can do this?
I hope I've explained my situation well enough to get help. If not let me know.
Thanks,
Don......
I want to be able to query this data according to date, from the beginning of one month to the end of that month for example. The problem is when I do this my report shows every record for that time period, which may be a couple of hundred. I'm still looking for only the totals for each of the 22 products. Is there a way I can do this?
I hope I've explained my situation well enough to get help. If not let me know.
Thanks,
Don......
