Search results

The model prices are updated each quarter from our supplier, which is why I have named the fields Q42017 etc. What we want to see is a column for the base model and it's price and a column for a comparative model and it's price. The relationship table is as follows:

Hi, I am trying to do a lookup for a price on a comparative shoe model. I have a model table (table name is Model) which lists comparative models and a separate table listing the prices (table name is ModelPrices)which are updated quarterly. I have built a query to show models, their price and...