Originally Posted by
mrbaggins
Related problem, I have a drop down elsewhere in the program that displays a list of activities and lets the user jump to a specified one in the form. Is there someway to make a drop down show information from 2 or more separate fields? Even better, to show information from 2 or more separate fields, PLUS format it? (IE: Make it pull name and date, but display "Cricket (2010)")
Sure. Use a calculate query field
Example In Query Designer:
Code:
DisplayText: [Namefieldname] & " (" & Tear([dateFieldName]) & ")"
Example In SQL:
Code:
[Namefieldname] & " (" & Tear([dateFieldName]) & ")" as DisplayText