Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
pulling multiple query feilds into one report field
- Thread starter tarena
- Start date
Are you talking about a concatenation of all three fields, or will there only be one of the three fields populated for each record?
If you want to concatenate the fields, use this for the control source of a field on your report...
= [1st Shift] & ", " & [2nd Shift] & ", " & [3rd Shift]
But, if only one of the 3 fields will be populated for each record, try this for the control source...
= IIF(Not IsNull([1st Shift]), [1st Shift], IIF(Not IsNull([2nd Shift]), [2nd Shift], [3rd Shift]))
If you want to concatenate the fields, use this for the control source of a field on your report...
= [1st Shift] & ", " & [2nd Shift] & ", " & [3rd Shift]
But, if only one of the 3 fields will be populated for each record, try this for the control source...
= IIF(Not IsNull([1st Shift]), [1st Shift], IIF(Not IsNull([2nd Shift]), [2nd Shift], [3rd Shift]))
- Status
Similar threads
- Locked
- Question
- Locked
- Question