Search results for query: *

I am attempting to use Switch in an Access query statement (using query builder). My statement looks like : FunctionName: Switch([Table!column] in ("1st"), "First", [Table!column] in ("2ndTest"), "Second"). (there are considerably more conditions) After copying and pasting the statement into...

Thank you very much. Your answer brings up two more questions. Why are parameter prompts to be avoided? And if I create a new seperate table for the dates, how do I join it to the other tables?

I have written several Access reports based on multi-join queries, and have a question. For many of these reports there is a section on the upper right where I display the date range that the data is valid for. Is there some feature that would allow me to to use a subreport or embedded feature...

No, I haven't tried subforms. Do you mean displaying manager info in the form and employees on the subform?

How do I set up a multi-query MS Access form? Both queries ask the users for input parameters. Actually, both queries use the same tables, but different joins. I'm trying to list a manager line, with detail lines below for each employee managed.