Hi
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.

[LastDate]![LastOfBalDate]< Now()

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
liz

Create a form with a textbox. Use the textbox inside the query to delimit the dates needed. Run the macro from a button on the form. Enter the date (or dates) in the textbos and it should run.



Sal