B
btamsgn
Hi Everyone,
I want to create a report with the format as follows:
PAGE 1 :
MATERIAL CODE STYLEA STYLEB STYLEC
DM|TLHH|NEED DM|TLHH|NEED
DM|TLHH|NEED
FABRIC 1 0.5 | 3 | 1500 0.78 | 3 | 1800
0.65 | 3 | 1550
LABEL 2 1 | 3 | 3000 2 | 3 | 3600
3 | 3 | 4650
ZIPPER 5 2 | 3 | 6000 1 | 3 | 1800
2 | 3 | 3000
PAGE 2 :
MATERIAL CODE STYLED STYLEE STYLEF
DM|TLHH|NEED DM|TLHH|NEED
DM|TLHH|NEED
FABRIC 1 0.45 | 3 | 1500 0.68 | 3 | 1800
0.66 | 3 | 1550
LABEL 3 1 | 3 | 3000 2 | 3 | 3600
3 | 3 | 4650
ZIPPER 9 2 | 3 | 6000 1 | 3 | 1800
2 | 3 | 3000
Pls advise in access2003, I can make a report as above.
If yes, Pls help & make a sample, thanks.
Thanks,
Tammy
I want to create a report with the format as follows:
PAGE 1 :
MATERIAL CODE STYLEA STYLEB STYLEC
DM|TLHH|NEED DM|TLHH|NEED
DM|TLHH|NEED
FABRIC 1 0.5 | 3 | 1500 0.78 | 3 | 1800
0.65 | 3 | 1550
LABEL 2 1 | 3 | 3000 2 | 3 | 3600
3 | 3 | 4650
ZIPPER 5 2 | 3 | 6000 1 | 3 | 1800
2 | 3 | 3000
PAGE 2 :
MATERIAL CODE STYLED STYLEE STYLEF
DM|TLHH|NEED DM|TLHH|NEED
DM|TLHH|NEED
FABRIC 1 0.45 | 3 | 1500 0.68 | 3 | 1800
0.66 | 3 | 1550
LABEL 3 1 | 3 | 3000 2 | 3 | 3600
3 | 3 | 4650
ZIPPER 9 2 | 3 | 6000 1 | 3 | 1800
2 | 3 | 3000
Pls advise in access2003, I can make a report as above.
If yes, Pls help & make a sample, thanks.
Thanks,
Tammy