Macro to Table

[Rkeev]

Greetings All,

I have pulled out enough hair to create my own wookie trying to get a cross tab query to work from a table filtered by a macro.

Soooooooo, how do you create a table from a macro that filters an existing table? Or is there another way?

Let be clear. I have a table (TBL 1) that lists info for the entire month. I have a crosstab query for this table; works fine but I need to further filter it.
Because I have so many issues filtering a Crosstab, I created a macro that filters this table (Tbl 1) based on user inputs into a form (frm1).

What I would like to do is create a Table (Tbl2) from this Macro then create a crosstab in Tbl2. Clear as mud?

any help would be appreciated.

Rick

 

[alansidman]

Look at a Make Table Query. Take your existing crosstab query and use it as the record set and select Make Table query.

 

[Rkeev]

Alansidman, outstanding advice; worked like a charm.

thanks eversomuch
Rick