Sacha Walter
asked on
Access 2010 - How to set a constant to a query result
Hi Experts,
I have a database with a table (t_datadate). I have a query q_DataDate_MAX which uses Max to find the most recent date. I often have to join this query to a date field in other queries to filter for one date, however, I was hoping I could just use something that acts like a global constant under Criteria in the query grid instead. Since the max date often changes, I know I can't define a constant as a specific date (I've found VBA examples on this), but wondering how I could have the constant equal to the result of the Max date query? Maybe I'm using the wrong concept to try and accomplish this, so please forgive my ignorance : )
I have a database with a table (t_datadate). I have a query q_DataDate_MAX which uses Max to find the most recent date. I often have to join this query to a date field in other queries to filter for one date, however, I was hoping I could just use something that acts like a global constant under Criteria in the query grid instead. Since the max date often changes, I know I can't define a constant as a specific date (I've found VBA examples on this), but wondering how I could have the constant equal to the result of the Max date query? Maybe I'm using the wrong concept to try and accomplish this, so please forgive my ignorance : )
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER