How Do I Control The Prompt Order of the Parameters?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi.

I have a query that prompts for city and hire date. I would like to prompt
for the hire date first, without changing the order at the bottom of the
query.

Is this possible? Any help would really be appreciated.

Thank you.

Troy
 
You can add the criteria in the select so it will prompt it first

For example, if you have
Select Field1 , Field2 from Tablename Where Field1 = [a] And Field2 =

it will prompt first the a and then the b
=============================
If you want it to prompt first the b, then add the b to the select

Select , Field1 , Field2 from Tablename Where Field1 = [a] And Field2 =


-
Please respond to the group if your question been answered or not, so other
can refer to it.
Thank you and Good luck
 
Thanks, that works great.

Thanks for all your help.

Troy

Ofer said:
You can add the criteria in the select so it will prompt it first

For example, if you have
Select Field1 , Field2 from Tablename Where Field1 = [a] And Field2 =

it will prompt first the a and then the b
=============================
If you want it to prompt first the b, then add the b to the select

Select , Field1 , Field2 from Tablename Where Field1 = [a] And Field2 =


-
Please respond to the group if your question been answered or not, so other
can refer to it.
Thank you and Good luck



Troy said:
Hi.

I have a query that prompts for city and hire date. I would like to prompt
for the hire date first, without changing the order at the bottom of the
query.

Is this possible? Any help would really be appreciated.

Thank you.

Troy
Click to expand...
Click to expand...
 
Back
Top