Hi, I am a novice now using Access 2003 for my job. Each month I need to modify and run over 100 queries that I must update with a date range in a criteria field. An example of the field that I must update is: "Between #5/31/2014# And #6/27/2014#".
Question: Is there a way that I can update the date criteria once (like in a table) then modify the queries so that they will use this modified date? That way, I would only need to modify the date in one place instead of modifying all of the separate queries each month.
Keep in mind that I am a novice, so you might need to keep answers simple for me to understand. Any help would be greatly appreciated. Thanks!
Question: Is there a way that I can update the date criteria once (like in a table) then modify the queries so that they will use this modified date? That way, I would only need to modify the date in one place instead of modifying all of the separate queries each month.
Keep in mind that I am a novice, so you might need to keep answers simple for me to understand. Any help would be greatly appreciated. Thanks!