Make table query makes a table automatically

  • Thread starter Thread starter lynda
  • Start date Start date
L

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
 
I have a form based on the table Test.
Click to expand...

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.
 
Back
Top