B
bill
Is it possible to have data in a report that comes from
more than 1 query?
If so, how?
Thanks
Bill
more than 1 query?
If so, how?
Thanks
Bill
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
B
Bruce
I doubt that it is possible, but even if it is, why would
you want to do that? If the several queries contain all
of the needed data, just make one query containing all of
the fields, and use that as the record source.
you want to do that? If the several queries contain all
of the needed data, just make one query containing all of
the fields, and use that as the record source.
B
bill
I do have 1 query containing all of the data I need,
however, I need to be able to report on the data in both
a record format and in a summary format. I cant figure
out how to put a condition on a control source property,
such as
sum(Abs([FPI]=5)) when [forms]![formVar]![value] = [jobno]
however, I need to be able to report on the data in both
a record format and in a summary format. I cant figure
out how to put a condition on a control source property,
such as
sum(Abs([FPI]=5)) when [forms]![formVar]![value] = [jobno]
B
Bruce
I may not be the person who should be trying to answer
your question. Having said that, I do have a question of
my own: What do you mean by "record format"? Do you mean
all of the fields in the query, as opposed to selected
highlights? Also, under what circumstances do you need to
put conditions on control sources?
your question. Having said that, I do have a question of
my own: What do you mean by "record format"? Do you mean
all of the fields in the query, as opposed to selected
highlights? Also, under what circumstances do you need to
put conditions on control sources?
-----Original Message-----
I do have 1 query containing all of the data I need,
however, I need to be able to report on the data in both
a record format and in a summary format. I cant figure
out how to put a condition on a control source property,
such as
sum(Abs([FPI]=5)) when [forms]![formVar]![value] = [jobno].-----Original Message-----
I doubt that it is possible, but even if it is, why would
you want to do that? If the several queries contain all
of the needed data, just make one query containing all of
the fields, and use that as the record source.
.
D
Duane Hookom
If you want to show both detail information and then grouped information in
a report footer, you can create a summary query of your totals. Then create
a subreport based on the summary query and stick it in the report footer.
--
Duane Hookom
MS Access MVP
a report footer, you can create a summary query of your totals. Then create
a subreport based on the summary query and stick it in the report footer.
--
Duane Hookom
MS Access MVP
bill said:I do have 1 query containing all of the data I need,
however, I need to be able to report on the data in both
a record format and in a summary format. I cant figure
out how to put a condition on a control source property,
such as
sum(Abs([FPI]=5)) when [forms]![formVar]![value] = [jobno]-----Original Message-----
I doubt that it is possible, but even if it is, why would
you want to do that? If the several queries contain all
of the needed data, just make one query containing all of
the fields, and use that as the record source.
.