473,325 Members | 2,870 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,325 software developers and data experts.

A query that compares different values

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?
Nov 12 '05 #1
1 3873
I would recommend against creating types that include brand in them.
To make simple and efficient design, make your tables hold only the
logically identical information. Thus, the type would be just Summer or
Winter (can be done by making a IsWinter field of Yes/No type). I would
also create separate tables for Manufacturers, Size and Options such as
WhiteRaisedLetter and others. In fact, you can easily do this by
splitting your existing table, even by using an Access wizard.
Then it becomes very easy to fill in the details in a junction table
using primary keys from all the main tables.
However, this is all in theory. I know that once you have a database,
you become hesitant to make changes to the design. Therefore, post here
your table structure (tables names and field names), and people may be
able to help you better. I am convinced that your question can be best
answered using properly constructed queries.

Pavel

Geir Baardsen wrote:

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?

Nov 12 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

5
by: Warren Wright | last post by:
Hi group, I have a select statement that if run against a 1 million record database directly in query analyzer takes less than 1 second. However, if I execute the select statement in a stored...
22
by: Robert Brown | last post by:
suppose I have the following table: CREATE TABLE (int level, color varchar, length int, width int, height int) It has the following rows 1, "RED", 8, 10, 12 2, NULL, NULL, NULL, 20...
4
by: Orion | last post by:
Hi, This is kind of last minute, I have a day and a half left to figure this out. I'm working on a project using ms-sqlserver. We are creating a ticket sales system, as part of the system, I...
1
by: Eskil | last post by:
Hi I have a form that supplies my query with information on two different variables. The form uses a lookup to display a list of 5 different customer types and 5 different types of...
9
by: Christine | last post by:
It has come to my attention that sometimes, when I open a Query in SQL View, the SQL that I see is not exactly the same as the SQL in the Query's Querydef. The difference I see (only occasionally)...
19
by: bdt513 | last post by:
I am trying to extract the values from a query using VBA. Specifically, I want to concatenate all the values of the "rosEmail" field from query "qselRosterEmailList" into one string (strEmails). I...
0
by: Ed | last post by:
All of a sudden my previously working code started throwing this error. from the SqlDatasource. I am using C# and Asp.net 2.0. Getting the following error: You have specified that your delete...
0
by: phlype.johnson | last post by:
I'm struggling to find the best query from performance point of view and readability for a normalized DB design. To illustrate better my question on whether normalized designs lead to more complex...
11
by: funky | last post by:
hello, I've got a big problem ad i'm not able to resolve it. We have a server running oracle 10g version 10.1.0. We usually use access as front end and connect database tables for data extraction....
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.