var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Make Table or Name Table From UNION ALL Query
This query work flawlessly.
Is there a way to either rename, or Make Table from this query?
Okay - I found it searching on the Web.
Here is the link: ACC2000: How to Create a Make-Table Query with a Union Query This link is optomized for IE of course!
Basically you create the UNION ALL query first - save it.
Then create another query based on the FIRST saved query.
Change the second query to a MAKE TABLE query and there you have it.
Save the second query.
Please see the link. Hope this helps someone.
Last edited by Rick Schreiber; 05-22-09 at 16:54.