Make table query makes a table automatically

[lynda]

I have a make table query with fields: projectname,
projectleader,Invoiced In 2002, Jan, Feb, Mar,..., Dec.
The values in months (Jan, Feb, Mar,..) are invoiced
amount in that particular month. Table Test is made by
this query. I have a form based on the table Test. I want
the query is automatically updated at 6pm everyday. What I
mean is that the makeTest query will automatically make
table Test, and I don't have to click any button to make
the event happen. Can anyone help me on this? Thanks!
Best regards
Lynda

 

[[MVP] S. Clark]

Total Visual Agent will assist you with scheduling the event.
http://www.fmsinc.com/products/agent/index.html

--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

 

[John Vinson]

I have a form based on the table Test.

I'd suggest instead basing your form on a Select (or Crosstab, it
appears) query rather than going to the extra effort of running an
expensive and bloating MakeTable query; if you do so, the data in the
form will be accurate up to the minute, not to the previous day.