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.
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.