Recent content by 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...

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