Reports within Reports and only list 5 records

  • Thread starter Thread starter Michael Kintner
  • Start date Start date
M

Michael Kintner

I have a report within a report. The report within I only want to see the
first 5 records. I have tried using the top command with no luck.
Sometimes I see 1 records when there are 20 and other times I see 100
records when there are thousands.

Any ideas on how to make this work?

Thank you in advance for any help,
Mike
 
Hello Miachael.

Michael said:
I have a report within a report. The report within I only want to see
the first 5 records. I have tried using the top command with no luck.
Sometimes I see 1 records when there are 20 [...]
Click to expand...

That's 5 percent...
[...] and other times I see 100 records when there are thousands.
Click to expand...

.... if there were 2 thousands, that was also 5 persent.
Any ideas on how to make this work?
Click to expand...

You maybe have used "Top 5 percent". Try "Top 5" instead.
Maybe you can post the query/control settings?
 
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

Access Access Record Order 0
How can I only show part of a list in a report? 3
Reports and Records Displayed 1
Filter within a report 4
Help! with query criteria for report 3
Creating a report 4
Deleting many forms or queries or reports 11
Access report preview and print only the first page 2

Back
Top