Hi!
I might have a difficult cuestion.
In our database we have registered different tyres with different
dimensions from different suppliers that is both for summer and winter
season.
Now I have simplified the database by having a tblCategory, so that I
can run queries with this condition. So all tyres that are for
summerseason, will be in the category: Tyres/su-Pirelli and tyres for
winterseason will be in the category: tyres/wi-pir and so on...
Now I want to construcy a query that compare prices for the same
dimension, say 175/80-13 (with the suffix H or T or whatever...) and
have it shown in a form or maybe a report.
I must admit - I'm blank here. This seems to be possible only in code?
As it is for now I have made a query, limiting the choice by: Like
"tyres/su-pir*" as a condition in the query. So I have copied this
query, one for each sort of tyre, and the user can open each query to
compare prices. A bit slow and "un-proffesional" I think.
Anybody that know how I should go around?