K
Kim NJ
Okay, I finally have all of my tables and data set up for an equiment
maintenance report. I got all of the data coming out of one table and
dumping into subreports based on the equipment itself. (in the table, if the
field doesn't apply to the equipment, it is simply left blank...only the
fields for that piece of equipment are filled in based on my form designs)
Here's the issue:
I set up my report with one main report from one query based on one table.
The subreports are based on another query from another table. I need the
most user-friendly way to produce a report using my 'weekstartdate' field. I
already know how to build the form and have a single query point to the form
to generate the report. (using Microsoft Help...Using Parameters with
Queries and Reports).
When building the report, based on info I searched out in communities, I
have the subreports filtered as children of the main report based on the
'weekstartdate'. Unfortunately, every time I enter new data into that main
table, my subreports duplicate!!!
I did something horribly wrong somewhere!!!
The good news is that the data in both queries is linked in a relationship
(a general one...not one to many or anything...no referential integrity used)
and are formatted identically.
I want to create ONE form with ONE dropdown that will send that date
selected out to all of my subreports as well as the main report to produce
one cohesive, non-duplicated report.
Do I need to eliminate the filtering? I know this is the root of the
mysterious duplicating subreports.... The subreports are based off of the
same query...so can Ijust point the single query to that form as well as the
main query?
I'm so confused!!!
maintenance report. I got all of the data coming out of one table and
dumping into subreports based on the equipment itself. (in the table, if the
field doesn't apply to the equipment, it is simply left blank...only the
fields for that piece of equipment are filled in based on my form designs)
Here's the issue:
I set up my report with one main report from one query based on one table.
The subreports are based on another query from another table. I need the
most user-friendly way to produce a report using my 'weekstartdate' field. I
already know how to build the form and have a single query point to the form
to generate the report. (using Microsoft Help...Using Parameters with
Queries and Reports).
When building the report, based on info I searched out in communities, I
have the subreports filtered as children of the main report based on the
'weekstartdate'. Unfortunately, every time I enter new data into that main
table, my subreports duplicate!!!
I did something horribly wrong somewhere!!!
The good news is that the data in both queries is linked in a relationship
(a general one...not one to many or anything...no referential integrity used)
and are formatted identically.
I want to create ONE form with ONE dropdown that will send that date
selected out to all of my subreports as well as the main report to produce
one cohesive, non-duplicated report.
Do I need to eliminate the filtering? I know this is the root of the
mysterious duplicating subreports.... The subreports are based off of the
same query...so can Ijust point the single query to that form as well as the
main query?
I'm so confused!!!