Hi,
I have query that join two tables together.
Table 1
Site Element
A-1 Iron
A-1 Copper
A-1 Zinc
B-2 Iron
B-2 Lead
Table 2
Element Percent
Iron 60%
Copper 20%
Joins into Query 3
Query 3
Site Element Percent
A-1 Iron 60%
A-1 Copper 20%
A-1 Zinc
B-2 Iron 60%
B-2 Lead
I need to update the Percent field to set any blanks to 100%. I know an UPDATE query would easily do this, but only if it were a table.
I'd like to be able to run something like an UPDATE query on Query 3. Reason for this is that I have other queries that are run on Query 3 afterwards and I don't want to have to insert it into a table and manually run an UPDATE query each time.
So repeating my question, is it possible to run something like an UPDATE query on Query 3? Any help would be much appreciated. Thanks.
Everest
I have query that join two tables together.
Table 1
Site Element
A-1 Iron
A-1 Copper
A-1 Zinc
B-2 Iron
B-2 Lead
Table 2
Element Percent
Iron 60%
Copper 20%
Joins into Query 3
Query 3
Site Element Percent
A-1 Iron 60%
A-1 Copper 20%
A-1 Zinc
B-2 Iron 60%
B-2 Lead
I need to update the Percent field to set any blanks to 100%. I know an UPDATE query would easily do this, but only if it were a table.
I'd like to be able to run something like an UPDATE query on Query 3. Reason for this is that I have other queries that are run on Query 3 afterwards and I don't want to have to insert it into a table and manually run an UPDATE query each time.
So repeating my question, is it possible to run something like an UPDATE query on Query 3? Any help would be much appreciated. Thanks.
Everest