Lookup from a table with column reference

[jibb]

Hello,

I have a table to look up customer prices. The column headings are the customer name and the first column in the product code. How can I look up a price from the spcified column (by name) and by the product code in the first column?

 

[spikepl]

Your data is not normalized. Customer names have no business in column heading (that is Excel -in Access you can perhaps display data in this manner, but you do not store it like that). All queries, forms and reports become a pain to make because of that. Normalize your data. If you don't know what that is google database normalization

 

[jibb]

Thats what I thought. How would you construct a table to show prices for the same products for different customers?