Hi,
I have 5 independent append queries.My requirement is
that the result of these queries has to update the single
row in the destination table.Is my approach correct in
going for append query?How to go about updating the single
row
subbu
Dear Subbu:
An append query adds rows to a table but does not update any of the
existing rows of the table. An update query does not change the
number of rows in a table, but can change certain columns in specified
rows of the table.
To update a single row, there must be some unique key to that row
specified in the WHERE clause of the update. I believe this is the
key to what you want to do.
But, you say, "the single row in the destination table." If indeed
there is only one row, you can dispense with the WHERE clause, thereby
updating all the rows in the table, which is to say the only row.
Your post has possibly quite confused me in these regards, but I have
tried to be of some help if possible.
Tom Ellison
Microsoft Access MVP
Ellison Enterprises - Your One Stop IT Experts