Report

[Lewy]

Whilst Im'e on a roll, I have a problem with a report I am trying to generate.

I have a single table with the following structure:

PartNo A20
Manufacturer A20
Description A92
Retail Price $

The partNo will have a reference number such as
s1, s1h, s1t, s1c or s1a
s2, s2h, s2t, s2c or s2a
etc

each partNo corresponds to a spectacle lens with either no surface treatment (s1), a hard coating (s1h), a Trio coating (s1t) etc.

I am trying to generate a printed price list along the lines of:

Lens Code Description Uncoated Hard coated Trio coated
h t

s1 Plastic Lens £20.00 £30.00 £40.00
s2 Glass Lens £25.00 £35.00 £45.00

and so on. Because the table structure is such that we have a list of codes going down the table

s1
s10a
s10h
s10t
etc.

How do I get the prices in the correct lines and columns? If I need to change the codes I am quite happy to, but the method of nameing I have used, means it is simple to look at the code and know roughly what type of lens it is, even though there are approx 170 different lens combinations.

Thanks as always.:

Lewy

 

[hcts]

It would seem to me that you could use two separate fields named "coating" and "type" and then throw it in a cross tab with the type going down and the coating going accross.