michaelak117
Registered User.
- Local time
- Today, 00:43
- Joined
- Mar 12, 2009
- Messages
- 37
Currently I am bringing in text and number data on a daily basis by importing and appending to an existing table. At this point query for the information I need which consists of some criteria(todays date being the most important).
I do this process twice on two existing tables. Then the goal is to Union query.
I have a form where I input todays date or through an expression could use the "current date" function. So I am automating todays date so I dont have to enter it daily and then opening an existing query based on the date which is tied to the form.
My data is daily and on daily basis I run a daily process. So what ive thought is can just save as this query everyday by the date, but obiously its tied to the form, so each time I open it im asked for the date causing me to enter the dates everyday. Also, if I want to open former queries from previous days ill have to enter that date. Furthermore, I take the two queries I referred to before that are a product of the two existing table and run union query, which required me to put in the date even more, which I would do not know how to automate. Am I going to far to automate this, Should simply open the query each day based on the existing tables and change the date, then save as. Then once done just run union query. Whats the best way to make a process like this automated and quick, with his date change issue??
I do this process twice on two existing tables. Then the goal is to Union query.
I have a form where I input todays date or through an expression could use the "current date" function. So I am automating todays date so I dont have to enter it daily and then opening an existing query based on the date which is tied to the form.
My data is daily and on daily basis I run a daily process. So what ive thought is can just save as this query everyday by the date, but obiously its tied to the form, so each time I open it im asked for the date causing me to enter the dates everyday. Also, if I want to open former queries from previous days ill have to enter that date. Furthermore, I take the two queries I referred to before that are a product of the two existing table and run union query, which required me to put in the date even more, which I would do not know how to automate. Am I going to far to automate this, Should simply open the query each day based on the existing tables and change the date, then save as. Then once done just run union query. Whats the best way to make a process like this automated and quick, with his date change issue??
