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
> Two Queries, One Date - Macro, Access 2016    
 
   
lollypop
post Nov 6 2018, 10:33 PM
Post#1



Posts: 155
Joined: 22-February 17
From: Deep South


Hi,

I have two queries that I'm working with that will need to be run with the same dates. I have written a macro to run the queries sequentially and am wondering if there is a way to only have to enter the dates once, rather than twice. I'm using Between [Start Date] And [End Date] for the dates.

Please help.
TIA!
Go to the top of the page
 
theDBguy
post Nov 6 2018, 10:58 PM
Post#2


Access Wiki and Forums Moderator
Posts: 73,751
Joined: 19-June 07
From: SunnySandyEggo


Hi,

One way is to use a form to enter the dates.

Hope it helps...

--------------------
Just my 2 cents... "And if I claim to be a wise man, it surely means that I don't know" - Kansas
Access Website | Access Blog | Email
Go to the top of the page
 
lollypop
post Nov 7 2018, 01:04 AM
Post#3



Posts: 155
Joined: 22-February 17
From: Deep South


Thanks. I set that up. Now, I have more than one query that would use that form. Is that possible or will I need to make a date form for each query I want to use it on?
Go to the top of the page
 
theDBguy
post Nov 7 2018, 10:53 AM
Post#4


Access Wiki and Forums Moderator
Posts: 73,751
Joined: 19-June 07
From: SunnySandyEggo


Hi,

Yes, you can use the same form for as many queries you want to ask the user to enter dates. Just refer to the name of the form and the controls on it. One thing to remember though is you'll need to make sure the form is open, with user input, before running the queries.

Cheers!

--------------------
Just my 2 cents... "And if I claim to be a wise man, it surely means that I don't know" - Kansas
Access Website | Access Blog | Email
Go to the top of the page
 


Custom Search


RSSSearch   Top   Lo-Fi    18th November 2018 - 09:53 PM