Append problem

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

mike@work - 22 Apr 2008 11:21 GMT

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.

Reply to this Message

Dale Fye - 22 Apr 2008 14:59 GMT

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

Signature

email address is invalid
Please reply to newsgroup only.

> 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
[quoted text clipped - 5 lines]
> this takes some time.
> any help with fixing the query would be greatly appreciated, ty.

Reply to this Message