fill data belong to field

T

Tammy Tran

Hi All,

I have a "datarpt" table :SELECT DATARPT.CP, DATARPT.CODE, DATARPT.NPL, DATARPT.UNIT, DATARPT.A, DATARPT.B, DATARPT.C, DATARPT.D, DATARPT.E, DATARPT.F, DATARPT.G, DATARPT.H, DATARPT.I, DATARPT.J, DATARPT.K, DATARPT.L
FROM DATARPT
ORDER BY DATARPT.CP, DATARPT.CODE;

and "need" query : SELECT STYLE.CP, STYLE.[No] AS StyleNo, STYLE.Style, NPL.[No] AS CODE, NPL.NPL, NPL.UNIT, STYLE.QTY, STYLEDE.DM, STYLEDE.TLHH, [QTY]*([DM]+[DM]*[TLHH]/100) AS NEED
FROM STYLE INNER JOIN (NPL INNER JOIN STYLEDE ON NPL.[No] = STYLEDE.[No]) ON STYLE.Style = STYLEDE.Style
ORDER BY STYLE.[No], STYLE.Style, NPL.[No];

I want to fill values from "need" query into "datarpt" table with the following fields :
ABC=styleA(A=DM,B=TLHH,C=NEED);DEF=styleB(D=DM,E=TLHH,F=NEED);GHI=styleC(G=DM,H=TLHH,I=NEED);JKL=styleD(J=DM,K=TLHH,L=NEED);

Pls help the situation.

I can't attach file, pls email : (e-mail address removed)


Thanks,
Tammy
 

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

create a report 0
Restart record count when the value in a specific field changes 3
Data in a column moved to same Row as related data 5
How do I use existing data from a worksheet to auto fill a second 0
Query - Table 3
two tables ... distinct data = me stumped 6
export query data to excel to create a mailer 0
return without gosub error 0

Top