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

Finding the Max Value using a loop

P: 2
Hello all...This is my first time posting here, and I am a newbie at all programming and access. I am trying to write a program but am stuck on a certain part.

I have a a form that has part_Number, Order_number, etc...and a Subform that has the part routing for each Order. On the Subform, the fields that I am having trouble with are Work_Center, Final_Value, and Value. My subform looks like this...

Work Center Value Final_value
854 12
856 20
852 32
819 8 32
854 7
856 16
819 16 16

The Work_Center is manually entered, the VAlue is a caclulation from other data in the subform, and the Final_Value field, I want some code that will take the Max number from the Value field, but I want it for each row that is 819. So the first 819 above would be 32 from the data above it, and the second 819 would be 16 from the highest value between it and the previous 819. Does this make sense?

Thanks for all of your help

Tara
Aug 9 '07 #1
Share this Question
Share on Google+
3 Replies


missinglinq
Expert 2.5K+
P: 3,532
You have posted this identical question twice within a thirty minute time frame; please do not do this again! The second post has been deleted.

From this site's FAQs:

Do Not Double Post Your Questions

Double posting is where you start a thread on a topic and then for some reason start another thread on exactly the same topic in the same forum. Please do not do this because

1. It makes it very hard for people to answer you especially if there are answers happening in all the threads you have started because they have to read 2 or more threads in order to see what has already been said.
2. It swamps the forum with your problem resulting in less attention for the other threads.

If you feel for some reason that you post has been overlooked (for instance it hasn't has any replies) please do not repost the question. Post a message to the thread you started, this will bump it back to the top of the thread list for the forum.

Linq
Aug 9 '07 #2

P: 2
Sorry about that...I didn't think the first one went through. This is my first time posting, so I wasn't sure.


You have posted this identical question twice within a thirty minute time frame; please do not do this again! The second post has been deleted.

From this site's FAQs:

Do Not Double Post Your Questions

Double posting is where you start a thread on a topic and then for some reason start another thread on exactly the same topic in the same forum. Please do not do this because

1. It makes it very hard for people to answer you especially if there are answers happening in all the threads you have started because they have to read 2 or more threads in order to see what has already been said.
2. It swamps the forum with your problem resulting in less attention for the other threads.

If you feel for some reason that you post has been overlooked (for instance it hasn't has any replies) please do not repost the question. Post a message to the thread you started, this will bump it back to the top of the thread list for the forum.

Linq
Aug 9 '07 #3

Rabbit
Expert Mod 10K+
P: 12,392
Are these records ordered in some logical way?
Aug 20 '07 #4

Post your reply

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