Report based on multiple queries

[bill]

Is it possible to have data in a report that comes from
more than 1 query?

If so, how?

Thanks
Bill

 

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

 

[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]

 

[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?

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

.

 

[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

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