I have a form that shows numbers from a table lets call it Col A. The number in col A is repeated over and over again say a product ID number. In Col B I have a second number like so
Col A Col B
10001 1
10001 2
10001 3
10001 4 and so on
10002 1
10002 2 and so on
I need to reference col A but then find the highest number in Col B in this case it would be 10001, 4 or the second set would be 10002,2 or what ever the highest number in Col B is because that number could be big. My customer knows the col A number puts it in the form but would like to hit a command button that looks to Col A as reference and then shows the highest number in Col B so they know what the next number in the set should be for them to enter. Thanks for any help Please know I am just learning Access.
Col A Col B
10001 1
10001 2
10001 3
10001 4 and so on
10002 1
10002 2 and so on
I need to reference col A but then find the highest number in Col B in this case it would be 10001, 4 or the second set would be 10002,2 or what ever the highest number in Col B is because that number could be big. My customer knows the col A number puts it in the form but would like to hit a command button that looks to Col A as reference and then shows the highest number in Col B so they know what the next number in the set should be for them to enter. Thanks for any help Please know I am just learning Access.