Reporting unique values from 2 different records

Joshin

New member
Local time
Today, 00:45
Joined
Jun 9, 2009
Messages
6
Hello, I was wondering if someone could help me with something.

Basically, what I want to do is go from one record to another, and make a list report of any of the values that aren't the same.

A example of how my table is build is this:

ID # (Key); Size (mm); Length (mm); Width (mm); Area (mm^2)
31133; 120; 50; 50; 800
31134; 120; 50; 60; 800

What the form is gonna look like is simple, just 2 combo boxes, in the format such as:

Going from <ID#> to the new <ID#>


So by "Going from 31133 to 31334" would simply just make a report saying

"Width (mm): 60"

This is basically asking for displaying what needs to be changed from going from 1 setting to another.

Thank you very much, I am very beginner when it comes to access but I learn very well just by keywords. If a query is needed please be detailed because I've literally never worked with creating a query before.

I will try to form up a access example to explain further.

Again, thank you.
 
Here's a link to my example, I know, really really basic. I apologize ahead of time :( I searched a lot of achieves in hope of finding out how to do this but I couldn't find anything that would accomplish this specifically. Is this possible to do?

http://www.mondaysaretragic.com/Example.mdb
 

Users who are viewing this thread

Back
Top Bottom