Append Query in Filter Name?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Please excuse my ignorance. I'm not sure if I can use the name of an Append
query in the filter name field of a macro without it actually....appending?
The records I need to come up in the form are in this query, but I do not
want them to add again. Basically I want the most recently appended records
to be displayed in my form. I'd also like to add a condition where if those
records have COMP in the Status field, they are not displayed. Could anyone
help with this? Thanks in advance.
 
No, you can't do that. make a copy of the append query, open it in
design mode and change it to a simple Select query, then just add the
"COMP" criterion on the Status field. When done, base the form on this
query.

HTH,
Nikos
 
Back
Top