M
Mike C
I have a select query that runs off a couple crosstab queries. The crosstab
queries are set up with fixed columns that show Mon, Tue, Wed, Thu, Fri. I
would like to add an expression field that gives me the maximum value from
Mon to Fri. I can't use the Max function because the Max function can only
evaluate 1 field at a time. Does anyone know a way around this or have an
ideas? Below is what I tried to do to get the Max value from Mon through Fri.
Max([Mon],[Tue],[Wed],[Thu],[Fri])
queries are set up with fixed columns that show Mon, Tue, Wed, Thu, Fri. I
would like to add an expression field that gives me the maximum value from
Mon to Fri. I can't use the Max function because the Max function can only
evaluate 1 field at a time. Does anyone know a way around this or have an
ideas? Below is what I tried to do to get the Max value from Mon through Fri.
Max([Mon],[Tue],[Wed],[Thu],[Fri])