A
at
Is there a way to get a maximum record based off of certain criteria? I have
a table that holds information for the weight of loads for a large container.
So my fields are containerID, loadID(auto#), and weight. Some containers
may have more than one weight so my information may look like this:
containerID loadID weight
ABC123 1 500
ABC123 2 75
CDE456 3 450
EFG111 4 700
GHI222 5 550
GHI222 6 50
I would like to narrow it down to where it always shows me the last weight
entered. I need a maxium on the loadID for each containerID. Most max
functions just give me loadID # 6, but I actually need to see loads 2, 3, 4,
& 6.
Any help is appreciated!!
at
a table that holds information for the weight of loads for a large container.
So my fields are containerID, loadID(auto#), and weight. Some containers
may have more than one weight so my information may look like this:
containerID loadID weight
ABC123 1 500
ABC123 2 75
CDE456 3 450
EFG111 4 700
GHI222 5 550
GHI222 6 50
I would like to narrow it down to where it always shows me the last weight
entered. I need a maxium on the loadID for each containerID. Most max
functions just give me loadID # 6, but I actually need to see loads 2, 3, 4,
& 6.
Any help is appreciated!!
at