Form Prompts

[Toan Chau]

Hi all!

I have a query with this heading in the Criteria
section..."[Which Underwriter?]".

I have a form that referances this question. Usually,
when it prompts me "Which Underwriter?" I would put in a
name and it would give me all accounts for that one
underwriter.

We have multiple underwriters. Instead of inputing each
Underwriter's name individual at the prompt and getting a
single report for each one, is it possible for me to get
accounts for all Underwriter all in one report?

Would it be possible for me to put a command like "All"
when it prompts me for "Which Underwriter"? So I get to
see all accounts from all Underwriters?

Is there such a command as "All"?

A thousand thanks in advance.
-Toan

 

[Marshall Barton]

I have a query with this heading in the Criteria
section..."[Which Underwriter?]".

I have a form that referances this question. Usually,
when it prompts me "Which Underwriter?" I would put in a
name and it would give me all accounts for that one
underwriter.

We have multiple underwriters. Instead of inputing each
Underwriter's name individual at the prompt and getting a
single report for each one, is it possible for me to get
accounts for all Underwriter all in one report?

Would it be possible for me to put a command like "All"
when it prompts me for "Which Underwriter"? So I get to
see all accounts from all Underwriters?

Is there such a command as "All"?

No there is no such command, but it's pretty easy to add
your own. Change the criteria to:

[Which Underwriter?] Or [Which Underwriter?]="ALL"

 

[Guest]

A thousand thanks, Marsh!!!

--Toan

-----Original Message-----

I have a query with this heading in the Criteria
section..."[Which Underwriter?]".

I have a form that referances this question. Usually,
when it prompts me "Which Underwriter?" I would put in a
name and it would give me all accounts for that one
underwriter.

We have multiple underwriters. Instead of inputing each
Underwriter's name individual at the prompt and getting a
single report for each one, is it possible for me to get
accounts for all Underwriter all in one report?

Would it be possible for me to put a command like "All"
when it prompts me for "Which Underwriter"? So I get to
see all accounts from all Underwriters?

Is there such a command as "All"?

No there is no such command, but it's pretty easy to add
your own. Change the criteria to:

[Which Underwriter?] Or [Which Underwriter?]="ALL"

 

[Toan Chau]

A thousand thanks, sir!!

--Toan

-----Original Message-----

I have a query with this heading in the Criteria
section..."[Which Underwriter?]".

I have a form that referances this question. Usually,
when it prompts me "Which Underwriter?" I would put in a
name and it would give me all accounts for that one
underwriter.

We have multiple underwriters. Instead of inputing each
Underwriter's name individual at the prompt and getting a
single report for each one, is it possible for me to get
accounts for all Underwriter all in one report?

Would it be possible for me to put a command like "All"
when it prompts me for "Which Underwriter"? So I get to
see all accounts from all Underwriters?

Is there such a command as "All"?

No there is no such command, but it's pretty easy to add
your own. Change the criteria to:

[Which Underwriter?] Or [Which Underwriter?]="ALL"