OK, earlier I was trying to use a query that I would normaly use in SQL to grab the lowest valued 'OP' for each 'Facility Code'/'Order Number' pairing. This is contained in the bottom half of the union query shown below.OK, earlier I was trying to use a query that I