By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
445,841 Members | 1,736 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 445,841 IT Pros & Developers. It's quick & easy.

need help with updating table

P: 57
Hi,

Could someone help me with updating my table? I'm using access 97. I have a table that have # of tests and test reasons called testing. what I need is if there's any job with test reason "customer control" or "customer visit" then total test = the max of # test for that job - how many tests with test reason "customer control" or "customer visit".

For example: for job # 1234, we have total of 5 tests before we ship the product, but out of 5 test, there are 2 tests for customer control and 1 test for customer visit, then total number of tests should be only 2.

Could someone give me an idea or the code on how to do this? I've been trying to do this for couple of days and nothing worked.

Thank you in advance
Aug 8 '07 #1
Share this Question
Share on Google+
2 Replies


P: 57
Could someone please help me regarding this matter?

Thank you
Aug 13 '07 #2

Rabbit
Expert Mod 10K+
P: 12,389
Hi,

Could someone help me with updating my table? I'm using access 97. I have a table that have # of tests and test reasons called testing. what I need is if there's any job with test reason "customer control" or "customer visit" then total test = the max of # test for that job - how many tests with test reason "customer control" or "customer visit".

For example: for job # 1234, we have total of 5 tests before we ship the product, but out of 5 test, there are 2 tests for customer control and 1 test for customer visit, then total number of tests should be only 2.

Could someone give me an idea or the code on how to do this? I've been trying to do this for couple of days and nothing worked.

Thank you in advance
I'm confused, not by what you want but by how to go about achieving it. I have no idea how your tables are set up.
Aug 13 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.