Wrox Programmer Forums
|
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old June 7th, 2006, 06:03 AM
Friend of Wrox
 
Join Date: Jun 2005
Posts: 181
Thanks: 0
Thanked 0 Times in 0 Posts
Default Selecting Items From Reports

Hi All
I have a report with several thousand records. I want to select 50 records from the report is there any easy way to select these records rather than doing a query
Thanks

Brendan Bartley
__________________
Brendan Bartley
 
Old June 7th, 2006, 06:44 AM
Friend of Wrox
 
Join Date: Mar 2004
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
Default

What do you mean when you say "select 50 records?" Does that mean you want the top 50, some 50 that you parameterize? etc?

The way to do this is to use a form and then select parameters from controls on the form, and then open the report. You can't select anything once the report is open.

Does this help?


mmcdonal
 
Old June 7th, 2006, 08:05 AM
Friend of Wrox
 
Join Date: Jun 2005
Posts: 181
Thanks: 0
Thanked 0 Times in 0 Posts
Default

The selection of records is random based on account numbers.
Do I setup a form first and then select the records
Thanks

Brendan Bartley
 
Old June 9th, 2006, 07:05 AM
Friend of Wrox
 
Join Date: Mar 2004
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
Default

You can set up a form, and give it the controls you need to get the parameters for your report. Then add a button to open the report after taking and passing the parameters to the underlying query. You can either pass them using SQL text, or give the query criteria that look for values in your controls.

But you say the parameters are random? You have several thousand records and you want to get a random 50? Is that right?


mmcdonal





Similar Threads
Thread Thread Starter Forum Replies Last Post
how to automate selecting all items from list satish_k Pro VB.NET 2002/2003 0 October 3rd, 2006 06:23 AM
comparision among crystal reports and Data reports avats Crystal Reports 0 April 13th, 2005 01:01 PM
How to create/design reports with crystal reports BassmaniaQ Crystal Reports 0 December 14th, 2004 04:58 AM
Selecting once where there are many onlyu2 MySQL 1 March 25th, 2004 06:22 AM
displaying 6 items only having 20 items Lakshmi KS VB Components 1 February 17th, 2004 10:34 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.