Need to loop thru records to identify specific situation

[leanne123]

I have a table with the following fields:

CONTAINER NUMBER - 1 container no. can have several CS no.s
CS NUMBER - several CS no.s can belong to one container
Size
Type
ETD
ETA
etc...

I need to determine 3 things, first, I need to identify all containers where any of the size, type, etd. data is different across CS No.s on the same container. Additionally, I need to know what field contains the different values. Lastly, I need to quantify how many times a specific field shows up meeting the above criteria.

Please help me to get started.

 

[SBerthold]

What have you got so far for a sql statement?

 

[ArtieChoke]

Are you expecting to do this in VB? How many records will you need to process?

"I think we're all Bozos on this bus!" - Firesign Theatre