G
Guest
i am trying to get 3 subreports onto a report. the main report has the
following fields; date, serialnum, materialname, baseserial, baseweight,
conserial, conweight, regserial, regweight, totalweight, plant, and initials.
i currently have a query that pulls in the data for the main report, using
the serialnum field as a criteria (entered on a form that open the report).
i am wanting 1 subreport to show data that has the same base serial number as
the field [baseserial] from the main report. then another subreport that
uses the field [conserial] from the main report as its criteria. then the
third subreport will use the field [regserial] from the main report as it's
criteria. is there a way of doing this? how? so far all i've been able to
get it to do is ask for the base serial number for each line it shows. is
there a better way of doing this than with subreports? how? thanks in
advance for any help you can offer.
following fields; date, serialnum, materialname, baseserial, baseweight,
conserial, conweight, regserial, regweight, totalweight, plant, and initials.
i currently have a query that pulls in the data for the main report, using
the serialnum field as a criteria (entered on a form that open the report).
i am wanting 1 subreport to show data that has the same base serial number as
the field [baseserial] from the main report. then another subreport that
uses the field [conserial] from the main report as its criteria. then the
third subreport will use the field [regserial] from the main report as it's
criteria. is there a way of doing this? how? so far all i've been able to
get it to do is ask for the base serial number for each line it shows. is
there a better way of doing this than with subreports? how? thanks in
advance for any help you can offer.