Total Records Returned for Report (1 Viewer)

[TravelerOn]

Question:

I have a query that returns 5,997 records from a larger table of 16,000 records. On the report, I only want to see 150 of that 5,997. How do I tell Access to only show me the first 150....so that my report isn't over 500 pages long?

Yes, I've tried setting the total records returned on the Query properties. It isn't working. Is there another method?

 

[simongallop]

In the queries properties set TopValues to 150

 

[TravelerOn]

already did

I did that, and it didn't work.

 

[Jon K]

Did you use any Order in your query? If you use Top 150 with an Order By clause, it will return more than 150 records if there is a tie.

See if this helps. Create another query from your query to retrieve Top 150 records without specifying any order (type in the SQL View of a new query, replacing with the correct query name):-

SELECT TOP 150 *
FROM yourQuery

Run this new query.

 

[TravelerOn]

excellent

thank you.....works like a charm.