Report does not match query

  • Thread starter Thread starter TaylorLeigh
  • Start date Start date
T

TaylorLeigh

I have a query with 567 entries but the report from this query has only 197.
What settings have I made that would do this?
 
Where is the Hide Duplicates property? I do not see it on the report
properties.
 
You might have grouped the report, and included the bound controls in a group
header or footer, in which case only the first or last row per group would
show. If so move them to the detail section. You can keep any you want to
show at the head or foot of each group in the header or footer, but those
you want to show as individual rows should go in the detail section.

If you don't want a group header or footer you can either remove it
completely via the sorting and grouping dialogue on report design view, or
you can set its height to zero.

Ken Sheridan
Stafford, England
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

HELP PLEASE 3
Report Query Works 2nd Time, But Not 1st 14
Can't create a report from my query in Access 1
report using a subreport based on a crosstab query 5
Access Access Report Works on One Machine but not Another 3
how to pass a parameter to a query base of a query that is the base of a report 0
Running reports in a multiuser VB/Access environment 0
Include field not in table in report? 3

Back
Top