Product Comparison

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I’m trying to design a database to serve as a quick way to compare our
products with the competition; I created a table with just a couple of
entrees to test weather this database would provide us with desired results.
I’m unable to get the data from the table into a format that can serve us i.e.

Model Model Model Model
manufacturer
price
etc...

Can anyone help me with this?????
 
How are your tables set up? What data do you have to work with? How are you
making the connection between your products and your competitions in these
tables? What kind of comparisons are you looking to make when you're
finished?
 
You likely need to create a cross tab query
(probably also a Manufacture Tbl and a SpecificationTbl)
 
Its just one table and it looks like this

Manufacturer Model Size Weight Color Power Consumption
1
2
3
4


The data is both text and numbers, some fields are memo as they contain
both. I also have some fields that are just yes/no. I’m not sure what you
mean about making a connections with the competitions products. In the end
an ideal result would be to pick one of our models and have the database pull
similar competitor models in the format i showed previously. Thank you for
any help you can provide.

Karol
 
I played around with that cross tab query many times its not putting the row
headings one under the other put side by side, when I use the wizard to
create it only allows me to use the fields that are text as row or column
headings and those that are "memo" are not given as options. I would like to
keep it in one table but I guess I can split this info up but I don’t see the
benefit of that. Thanks for any help you can provide.

Karol
 
1 table is not going to do it. You should use 3 tables for this.

Table 1 : Your product information, 1 entry per model.
Table 2 : your competitors product information, 1 entry per model.
Table 3 : a table which links your products to similar competitors products.
1 field for your product ID, 1 field for theirs.

You would then write a query linking your product code to the link table and
the link table to your competitors. This way, you only need to
enter/maintain product information once.. and maintain the link between the
2. It will make for a much easier to support process.
 
Back
Top