Hi everyone,
I found the Access reports too limited to do what i wanted so i created
a module to export a crosstab query to an excel file, and then i modify
it as i want. My problem is that i created a unique query for every
"sector", saved them, and select the right one according to the user's
choice.
What i'd like to do is to create the crosstab query directly in VBA,
change the WHERE part for the sector i want to show and output it to
the excel file with or without saving the query (if not i'd like to
erase if afterwards, or replace it everytime).
I dont think the runSQL command would work since it only runs action
queries, and i dont think that it is possible to make a crosstab table
neither. Could anyone help me?
Thanx alot,
Mike