update query

R

Ra

I have one table with the following setting:

CSPC Run Week TOOLSET GROSS_PCS
A0122 09,02 1A0122 1000
A0122 09,02 1A0122 1500
A0122 09,03 1A0122 0
A0122 09,03 1A0122 150
A0122 09,04 1A0122 500
A0122 09,05 1A0122 1000
A0122 09,05 1A0122 800
A0122 09,05 1A0122 250

A0123 1A0122

I need to have another table that will look like that:

CSPC Run Week TOOLSET GROSS_PCS
A0122 09,02 1A0122 1000
A0122 09,02 1A0122 1500
A0122 09,03 1A0122 0
A0122 09,03 1A0122 150
A0122 09,04 1A0122 500
A0122 09,05 1A0122 1000
A0122 09,05 1A0122 800
A0122 09,05 1A0122 250

A0123 09,02 1A0122 0
A0123 09,02 1A0122 0
A0123 09,03 1A0122 0
A0123 09,03 1A0122 0
A0123 09,04 1A0122 0
A0123 09,05 1A0122 0
A0123 09,05 1A0122 0
A0123 09,05 1A0122 0

For the same TOOLSET value I need to have for the second CSPC (A0123):
Run Week field values same with the first CSPC (A0122) and,
GROSS_PCS value 0

I tried updating the field but with no success.
Thank you for your help,
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

update blank fields 3
VBA Coding Help for Beginner 0
Running balance for debit and Credit using query in Access 2007 0
crosstab problem 2
Complicated Vlookup and array 1
Formatting Help - Query Result for "Range" 3
data series color - conditional formatting 2
working out % of correctness gives #DIV/0! 2

Top