UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Extracting From Drop Down Box, Access 2010    
 
   
Alexander
post Feb 14 2020, 08:55 AM
Post#1



Posts: 3,452
Joined: 30-December 03
From: Glasgow, Scotland


Just need a little help please getting my head around the following....

I can extract all the results for a race and show position, name, club and speed.

We now have 14 clubs and I wondered how to extract the individual results for each club for a race.

I can do it manually for all 14 clubs (currently have 14 queries and 14 reports) but would like to know how it is possible to select a club from a drop down box and then just print the selected club from 1 query and 1 report.

Any help appreciated.
This post has been edited by Alexander: Feb 14 2020, 08:56 AM

--------------------
Alexander
Keep using the sunscreen!
Go to the top of the page
 
GroverParkGeorge
post Feb 14 2020, 09:11 AM
Post#2


UA Admin
Posts: 37,511
Joined: 20-June 02
From: Newcastle, WA


Yes, this is pretty common, in fact.

If your reports (and their corresponding queries) are otherwise identical, you can use ONE report with ONE parameterized query instead.

The WHERE clause in this query would refer to the control on the form from which you launch the report, something like this, but using your own object names.

"... WHERE RaceID = Forms!frmYourFormNameGoesHere.cboSelectOneRaceID "

--------------------
My Real Name Is George. Grover Park Consulting is where I did business for 20 years.
How to Ask a Good Question
Beginning SQL Server
Go to the top of the page
 
Alexander
post Feb 14 2020, 09:28 AM
Post#3



Posts: 3,452
Joined: 30-December 03
From: Glasgow, Scotland


Thanks George … yes the query and reports are identical except I have hard coded in the club name to the query and reports.(Bad practice I know but it does work but wanted a better and safer solution)

Yes .. I can see that method and as well as selecting only the required Club I can also use the Club name for the header of the report.

Many thanks

--------------------
Alexander
Keep using the sunscreen!
Go to the top of the page
 
GroverParkGeorge
post Feb 14 2020, 09:32 AM
Post#4


UA Admin
Posts: 37,511
Joined: 20-June 02
From: Newcastle, WA


Continued success with your project.

--------------------
My Real Name Is George. Grover Park Consulting is where I did business for 20 years.
How to Ask a Good Question
Beginning SQL Server
Go to the top of the page
 
Alexander
post Feb 14 2020, 10:00 AM
Post#5



Posts: 3,452
Joined: 30-December 03
From: Glasgow, Scotland


Thanks George .. working perfectly .. much appreciated.

--------------------
Alexander
Keep using the sunscreen!
Go to the top of the page
 
GroverParkGeorge
post Feb 14 2020, 10:08 AM
Post#6


UA Admin
Posts: 37,511
Joined: 20-June 02
From: Newcastle, WA


Well done.


--------------------
My Real Name Is George. Grover Park Consulting is where I did business for 20 years.
How to Ask a Good Question
Beginning SQL Server
Go to the top of the page
 


Custom Search


RSSSearch   Top   Lo-Fi    13th July 2020 - 09:42 AM