Compare two columns in a query

[Lv2valt]

I'm new at this. I want to compare two columns in a query. They are from different tables. One is the original install verision and the other is the updated version if there is one. I want to be able to see the max or highest software version. Any ideas?

 

[MichaelRed]

Hmmmmmmmmmmm,

This could get to be wormy.

I do not KNOW wheather all of the various "software" would have the same info re the "version". I would not even know how to programatically collect this info from all of the executable (?) software on a machine, much less the various applications file types.

Leaving that morass of UGLY questions aside, I would just "ASSUME" the best and create a calculated col:

Latest: IIF([Orig] < [Curr], [Curr], [Orig])

Again, with the &quot;leap of Faith&quot; ASSUMPTION, at least the software package would have the same format for Version level reporting, This would return either the (Content of) the [Orig] or [Curr] field. Variations on the theme are almost endless, so I will 'leave the remainder' to the student.

MichaelRed
mred@att.net

There is never time to do it right but there is always time to do it over

 

[Lv2valt]

Thanks a lot. It worked great.