I have 3 queries I run in one macro. Each of them prompt the user for a date (which is the same date for all 3). I don't want the user to have to enter the same date all three times. Here's where my date param is coming into play: DateDiff("m",[join_date],[Enter a Date])
This is in the 3 queries and I'd like to be able to have the user to enter it once and then have the 1st query pass it to the other queries within this same expression or whatever if you have a better idea. I've tried making this one query by doing an "OR" statement but I get no data. So I'm stuck with 3 queries right now.
Thanks.
Rob
This is in the 3 queries and I'd like to be able to have the user to enter it once and then have the 1st query pass it to the other queries within this same expression or whatever if you have a better idea. I've tried making this one query by doing an "OR" statement but I get no data. So I'm stuck with 3 queries right now.
Thanks.
Rob