"Label" field according to parameter query

[Ada01]

I have created a query to track a sales contest. the contest has three departments and two types of contests (cash and trip) all selling the same products but for different date ranges. the final report is a snap shot for current reporting period for each department.



Dept 1 with a date parameter of BETWEEN "01/01/2014" AND [Enter End Date for Dept 1 Cash Contest] "Criteria"
Dept 1 with a date parameter of BETWEEN "01/01/2014" AND [Enter End Date for Dept 1 Trip Contest] "OR"

is it possible in the next field in the Query to label the Cash parameter with the word cash and the trip with trip. These are currently separate queries and i want to bring them together so i can pivot on the "cash" and "trip"

Thanks

[June7]

Create fields in query with expression. Static value is a very simple expression:

In the Cash query, try:
ContestType: "Cash"

In the Trip query, try:
ContestType: "Trip"

How do you plan to 'bring them together' - UNION query?