I.T. Discussion Community!
-Collapse +Expand
Access
Search Access Group:

Advanced
-Collapse +Expand Access To/From
To/FromCODEGuides
-Collapse +Expand Access Store
PRESTWOODSTORE

Prestwood eMagazine

February Edition
Subscribe now! It's Free!
Enter your email:

   ► MB LobbyMicrosoft Access BoardAccess VBA Programming Topic   Print This     

Passing Value From One Query to Another

Passing Value From One Query to Another in Access VBA Programming topic (part of our Microsoft Access group).

Quick Search: Passing   Another   Passing Value   Passing Value One   Query Another  
jdoody
 (Inactive)
Midhurst, Ontario, Canada
Hi all! I'm new to this site, which I just happened to stumble upon. I have a question that is probably easy for a seasoned Access user. I have created a series of queries and have linked them in order to create a report consisting of current and prior year budget to actual totals. I am wondering how to pass values between queries - for example, user enters "6" - for month 6 - in query 1, how do I access this "6" as input for query 2?
 Posted 18 years ago (Thread Starter)
Comment Quote
About jdoody -Collapse +Expand
Visit Profile
Inactive member.
Member does not subscribe to this thread.
Email Not Verified!
Once email is verified, we will review and approve the account.
Web Presence Hidden.
Once above is taken care of, full Profile content will display including back links, about me, my message, custom Profile html, social networking links, message board signature, company profile, etc.

Post ID #7336, 1 replies
Thread Started 8/22/2002 5:30:00 AM
View Counter=2803
Last Reply Posted 7/31/2007 10:10:04 PM)
Location=Midhurst, Ontario, Canada  
Joined=18 years ago   MB Posts=3  
Most Recent Post
Don G
Elgin, IL USA

Your first query becomes input for your second query.  Just drag and drop the field from the first query to your new query design.  It works like a charm.  When you execute the 2nd query, it automatically updates results from the 1st query for its input.  Hope this helps.

 Posted 13 years ago
Comment Quote
About Don G -Collapse +Expand
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.

Post ID #12025 (Level 1.1)  Reply to 7336
Thread Started 7/31/2007 10:10:04 PM
View Counter=2
Location=Elgin, IL USA 
Joined=13 years ago   MB Posts=5  

Revive Thread!

Add a comment to revive this old thread and make this archived thread more useful.

Write a Comment...
Full Editor
...
Sign in...

If you are a member, Sign In. Or, you can Create a Free account now.


Anonymous Post (text-only, no HTML):

Enter your name and security key.

Your Name:
Security key = P1216A1
Enter key:
Icon: A Post    Thread    Idea    Important!    Cool    Sad    No    Yes    Includes a Link...   
Thread #7336 Counter
2803
Since 4/2/2008

Follow PrestwoodBoards on: 


©1995-2020 PrestwoodBoards  [Security & Privacy]
Professional IT Services: Coding | Websites | Computer Tech