macro - loop
I am trying to use a macro to run an Append Query. The number of times the query needs to run is determined by the number of months from a certain date to now. The problem that I am experiencing is in referring to a field in a query or table in the "repeat expression" part of the macro.
It seems the macro will only look for controls in forms or reports. How do I get it to look at a query?
thanks for your help