Cross Tab Query

[Bookbinder75]

I have a cross tab query. I then changed it to a make table query so I could then run a query on the new table to put a date parameter on the query. How do I get updated information after that? The information in the new table will stay stagnet and not update with any new entries. Any ideas are greatly appreciated.

 

[jimmythegeek]

Not if you run your make table query before you run the other query every time. The make table query will overwrite the old table with fresh data, each time you run it.