Query vs. Report Results

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a query that results in 3 records. When I run a report based on the
exact same query it only show 1 records. Any idea why this may be
happening???
 
Someone who asked a similar question earlier, had placed all controls in a
group section rather than detail section.

What result do you see with the following text boxes in the REPORT HEADER:
=[Filter]
=Count(*)
 
I get the same result. How can I tell if they are in a group section? Looks
to me that they are in the report detail. Does it matter that I have
subreports in there also?

Duane Hookom said:
Someone who asked a similar question earlier, had placed all controls in a
group section rather than detail section.

What result do you see with the following text boxes in the REPORT HEADER:
=[Filter]
=Count(*)

--
Duane Hookom
MS Access MVP
--

smboyd said:
I have a query that results in 3 records. When I run a report based on the
exact same query it only show 1 records. Any idea why this may be
happening???
Click to expand...
Click to expand...
 
How can you "get the same result" if these two text boxes were never in your
report before? What do you get for the results in the text boxes? What do
you see when you open the report's record source in datasheet view?

Where did the subreport come from and how is it used?

--
Duane Hookom
MS Access MVP
--

smboyd said:
I get the same result. How can I tell if they are in a group section?
Looks
to me that they are in the report detail. Does it matter that I have
subreports in there also?

Duane Hookom said:
Someone who asked a similar question earlier, had placed all controls in
a
group section rather than detail section.

What result do you see with the following text boxes in the REPORT
HEADER:
=[Filter]
=Count(*)

--
Duane Hookom
MS Access MVP
--

smboyd said:
I have a query that results in 3 records. When I run a report based on
the
exact same query it only show 1 records. Any idea why this may be
happening???
Click to expand...
Click to expand...
Click to expand...
 
Back
Top