I wanted to create a new version of an Access Query that selects MORE columns from a table in the current version.
I selected the existing query, did a save as & gave it a different name.
I added the new fields & saved the query.
Then I wrote a Macro to run the new query; then I ran the Macro.
See attached screen shots.
When the Macro is run, it produces the SAME result as the old Macro/query. The new columns are NOT there.
I need to know what I am doing wrong; of course, I can send more screen shots if needed.