473,400 Members | 2,163 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,400 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 3878
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: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

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.