G
Gerald Stanley
The Help file speaks the truth. The ORDER BY clause can
only relate to the columns output as it references the
column names assigned (either explicity or implicitly) in
the first part of the UNION. You will have to include your
hidden column if you wish to sort by it.
Hope This Helps
Gerald Stanley MCSD
help the only 'order by' field that I can add has to be one
that is selected in both queries that I'm joining.
only relate to the columns output as it references the
column names assigned (either explicity or implicitly) in
the first part of the UNION. You will have to include your
hidden column if you wish to sort by it.
Hope This Helps
Gerald Stanley MCSD
like to sort on a hidden field, but from what I've read in
help the only 'order by' field that I can add has to be one
that is selected in both queries that I'm joining.