Append problem

  • Thread starter Thread starter mike@work
  • Start date Start date
M

mike@work

I have several select queries all cascading to a point where i do a record
count. these works fine. i then have an append query that puts all the
record counts into a table, which also works fine.
the problem i have is that when 1 of the queries returns a null (or 0
recordcount) the append query returns no records at all. I have found a
workaround to this problem by openening a form, running all queries, goto
newrec, run all queries again and so on until the operation has finished, but
this takes some time.
any help with fixing the query would be greatly appreciated, ty.
 
Append queries don't "return records"

If you are joining these queries together, then a query with No results will
definately affect your append query.

Can you post the SQL for your append query?

Dale
 
Back
Top