Add Event To Automatically Run Make Table Query

[symphony]

I need it to do add an event to my database so that when a record is addded to table A, it automatically runs query B (Make table query) to update my totals in table C.

I currently use this database an ASP driven website.

Any help on how to make this happen will be appreciated.

Thanks,

Anthony

 

[plog]

Generally, you don't want to store totals in a table--you calculate them when you need them. That means instead of keeping them in Table C and running Query B everytime, you would instead just configure Query B to be an aggregate SELECT query which will generate the data you want.

Can you give the layouts of your tables and some sample data of each. Also, if you think you should store the totals in a table please explain why you believe that.

 

[symphony]

I need to use the result of the totals query in a couple of other new queries.

When I create further queries against the totals query, I get the message that the query is too complex.

However, if I create the totals query as a make table query, then I can write my additional queries against the update table.

It works manually, but that means I have to keep running the make table query manually whenever a new record is added.

I am trying to automate this process through an record add/change event.

Thanks,

Anthony

 

[DJkarl]

Access does not support table triggers like some more robust SQL systems (MYSQL, SQL Server, Oracle). You can capture these type of events through a form entry, but not through a query or direct table update, unless they added that functionality into A2k10 which I have not used yet.