Please help me with the design of this database

Hi guys, im new to Access and have this problem.

Ok, Ive got two reports.

One is a stock level count which is held internally, which we beleive to be
correct.

The second has the same fields but are filled in by companies we supply to.

Im trying to design a database which automatically (upon query) picks out
differences between the Fields (Product,Price and quantity)

The product is always going to stay the same between the two reports, but I
need to be told in which records the Price and Quantity differ.

Is this possible and what type of queries would i need to input!

You posted in a newsgroup that supports the design of data tables and
databases, but your description mentions your reports more than the
underlying data.

The first place to start in designing a well-normalized relational database
is to identify the things about which you want to keep information
("entities") and figure out how those things are related one-to-another
("relationships"). You can do this with paper and pencil, without ever
turning on your computer.

When you have a good handle on the entities, and what pieces of information
you want to save about each, you are ready to start designing tables in
Access.

Or perhaps you can locate a template at Microsoft.com that gives you a start
at designing your database?

Good luck on your project!

Regards

Jeff Boyce
Microsoft Office/Access MVP

"Amaretto" wrote in message
...
Hi guys, im new to Access and have this problem.

Ok, Ive got two reports.

One is a stock level count which is held internally, which we beleive to
be
correct.

The second has the same fields but are filled in by companies we supply
to.

Im trying to design a database which automatically (upon query) picks out
differences between the Fields (Product,Price and quantity)

The product is always going to stay the same between the two reports, but
I
need to be told in which records the Price and Quantity differ.

Is this possible and what type of queries would i need to input!

On Fri, 19 Jan 2007 12:27:29 -0800, Amaretto
wrote:

Im trying to design a database which automatically (upon query) picks out
differences between the Fields (Product,Price and quantity)

The product is always going to stay the same between the two reports, but I
need to be told in which records the Price and Quantity differ.

Is this possible and what type of queries would i need to input!

If you can RELIABLY count on the Product being the same between the
two tables, this isn't hard. If you have a product *name* - especially
if your coworkers are typing the name in - then that's very doubtful!
A "Left-handed 8mm widget" is not the same as a "Lefthanded 8 mm
widget".

But given a reliable (preferably numeric uneditable) primary key on
both tables, you can simply create a Query joining the two tables on
Product. Include the Price and Quantity fields from both tables. As a
criterion on the Price field in the second table put

[First Table].[Price]

and on the next line down under Quantity put

[First Table].[Quantity]

The second line uses OR logic. Use your own tablenames of course.

John W. Vinson[MVP]