HELP...Need help with an Update Query

[Guest]

I have a table titled tblCommissions whose records I need to update with
records from 4 separate queries. I originally created tblCommissions by
making the 4 queries into Append Queries successfully. However, now that
I've created the tbl, I need to figure out how I can ensure that as the
queries are updated, that those changes get recorded in tblCommissions. I've
tried converting the queries to "Update Queries" but am having no luck. I
really can't figure out how to use the Update Query function (if that is what
I need).

Help. I'm pulling my hair out.

 

[John Vinson]

I have a table titled tblCommissions whose records I need to update with
records from 4 separate queries. I originally created tblCommissions by
making the 4 queries into Append Queries successfully. However, now that
I've created the tbl, I need to figure out how I can ensure that as the
queries are updated, that those changes get recorded in tblCommissions. I've
tried converting the queries to "Update Queries" but am having no luck. I
really can't figure out how to use the Update Query function (if that is what
I need).

Help. I'm pulling my hair out.

Here's a heretical idea:

Delete tblCommissions.

It probably shouldn't exist, if the commissions can be calculated from
existing data. Simply create a Select Query (perhaps a UNION query, if
you have four different queries calculateing different commissions);
use this QUery as the recordsource for your forms and reports.

John W. Vinson[MVP]

 

[Guest]

John,

Thanks this worked beautifully. Never knew that there was such a thing as a
union query. It solved my issue.

Thanks,
A