Comparing data before updating

  • Thread starter Thread starter EMILYTAN via AccessMonster.com
  • Start date Start date
E

EMILYTAN via AccessMonster.com

Does anyone know how to compare data?
If same update the quantity else just ignore it?
 
Does anyone know how to compare data?
If same update the quantity else just ignore it?
Click to expand...

Emily, don't you have that backwards? If it's the same, then updating it will
change 123 to 123.

Please explain WHAT you are comparing to WHAT, and under what circumstances;
and what you want to update, and what you want to update it to.

Remember: YOU can see your database. YOU know what problem you're trying to
solve. We cannot, and we do not. All we can see is the two lines of text
you've typed - and maybe I'm just sleepy, but those two lines simply don't
make sense to me!

John W. Vinson [MVP]
 
I am sorry about this...
Really sorry...
Ok...I will explain to you right now..
I hope you can help me as I have tried a lot of method but still can
accompalish what I want.

Well, actually the purpose I am doing this is I want to differentiate between
new and old job...
Well, I cannot completely replace the old job to the new one because some
part number appear in new and old too...
So, that is why I need the new job to get the quantity kitted from the old
job where both of the part number exists for both job...

For example,
A job number AG123 has the following part number needed to built that job:-
10122-8900
12345-0990
11111-1111

Then for a new job under the same category, i put it as AG789 need the
following part number:-
10122-8900
00001-0000

So, I need the quantity kitted of 10122-8900 from AG123 to be transfered to
AG789....
Actually AG789 is the extended on AG123...
Note : There will be a column on the kitted quantity..just that I didnt show
it...but most important is the comparison part...

Will have a form prompt the user to enter the old and new job. Once the
button is being click, it will get all the quantity where the part number
exist in both of the job....

Clear?

Hope to hear from you soon...
 
I am sorry about this...
Really sorry...
Ok...I will explain to you right now..
I hope you can help me as I have tried a lot of method but still can
accompalish what I want.

Well, actually the purpose I am doing this is I want to differentiate between
new and old job...
Well, I cannot completely replace the old job to the new one because some
part number appear in new and old too...
So, that is why I need the new job to get the quantity kitted from the old
job where both of the part number exists for both job...

For example,
A job number AG123 has the following part number needed to built that job:-
10122-8900
12345-0990
11111-1111

Then for a new job under the same category, i put it as AG789 need the
following part number:-
10122-8900
00001-0000

So, I need the quantity kitted of 10122-8900 from AG123 to be transfered to
AG789....
Actually AG789 is the extended on AG123...
Note : There will be a column on the kitted quantity..just that I didnt show
it...but most important is the comparison part...

Will have a form prompt the user to enter the old and new job. Once the
button is being click, it will get all the quantity where the part number
exist in both of the job....
Click to expand...

I'm still not understanding your table structure.

You have a Job table. What fields are in the job table?

You have a table - somehow - relating Jobs to the parts required for that job.
What fields are in this table?

What does "kitted" mean?

I *THINK* you'll be able to create a Query on the Job table (with a criterion
of the job you'll get quantities from), joined to the JobParts table (which I
presume exists), joined by part number to a *second* instance of the JobParts
table, joined to a second instance of the Job table with a criterion of the
"to" job.

But since I don't know the structure... I'm not sure how or whether this can
be done.

It sounds like you're setting up a quite complex application. I'd really
suggest that you may want to hire a professional with good database skills,
preferably someone local who can come into your facility and actually see what
you're doing and how. It's never easy to communicate over the internet, but
when you're talking in a jargon that I don't understand, and I'm talking in a
jargon that you don't understand, and we're talking about something as
difficult as this project, it's especially problematic!

John W. Vinson [MVP]
 
Haha...OkOk/....
Glad that you actually replied...
Thanks for your attention ya...
I am sorry about this...
Really sorry...
Click to expand...
[quoted text clipped - 29 lines]
button is being click, it will get all the quantity where the part number
exist in both of the job....
Click to expand...

I'm still not understanding your table structure.

You have a Job table. What fields are in the job table?

You have a table - somehow - relating Jobs to the parts required for that job.
What fields are in this table?

What does "kitted" mean?

I *THINK* you'll be able to create a Query on the Job table (with a criterion
of the job you'll get quantities from), joined to the JobParts table (which I
presume exists), joined by part number to a *second* instance of the JobParts
table, joined to a second instance of the Job table with a criterion of the
"to" job.

But since I don't know the structure... I'm not sure how or whether this can
be done.

It sounds like you're setting up a quite complex application. I'd really
suggest that you may want to hire a professional with good database skills,
preferably someone local who can come into your facility and actually see what
you're doing and how. It's never easy to communicate over the internet, but
when you're talking in a jargon that I don't understand, and I'm talking in a
jargon that you don't understand, and we're talking about something as
difficult as this project, it's especially problematic!

John W. Vinson [MVP]
Click to expand...
 
Back
Top