Search results

pbaldy - spikepl, Thanks! I never thought about puling in the data like that. I forced the part# to have no duplicates. Thinking about your suggestion on the structure, the source file records each have a date field as well that would further delineate. I cooked the books using Excel before...

Ah, gotcha - thanks again. For this particular case each of the price fields comes from a different database, which are linked to the part#. Completely different databases that are controlled by different entities. I have to use a web query to gather the info from the multiple sources and...

Not normalized? Not sure what you mean since all values are unique.... I'll check out the link at work. I googled and that never popped up, so I appreciate the link!

Greetings, Is there a practical method to find the max value of several fields in each record? The actual table is quite large, so I'll have to go with a sample.... Item# Price1 Price2 Price3 Price4 PriceMAX A1401 $10.41 $12.99 $11.05 $18.76 ?<-------(would be $18.76) A1798 $14.01 $17.79...