Ive got 2 tables. Table 1 contains different products and Year 1 sales.
Table 2 contains the same prds but also the department which catogorises each prd.
Each dept is represented as a code. What I'd like to do is to write a query that combines Prd, year1 sales and dept into 1 table. Ive done this but what I really need to to combine these but to somehow include only the first letter of the dept so say ive got the following in different cells:
Prd1, D10A2 (dept), 1020 (£)... I want :
Prd1, D, 1020.
Is there an easy way to do this?
Many Thanks
Table 2 contains the same prds but also the department which catogorises each prd.
Each dept is represented as a code. What I'd like to do is to write a query that combines Prd, year1 sales and dept into 1 table. Ive done this but what I really need to to combine these but to somehow include only the first letter of the dept so say ive got the following in different cells:
Prd1, D10A2 (dept), 1020 (£)... I want :
Prd1, D, 1020.
Is there an easy way to do this?
Many Thanks
