Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
MattieBala69
Starting Member
30 Posts |
 Posted - 2005-08-30 : 10:29:12
|
| I am trying to write a query where it has 3 diff parameter. one is Start Date , End Date and Employee Name. But the problem i have is my manager would like the user to pick an employee name from a list . Is there a way to write a quety where when i run the query , when it pops up with the box to enter parameters. To show all the employees so that user can pick any no of employess namesThank you,Mattie |
|
|
JimL
SQL Slinging Yak Ranger
1537 Posts |
Posted - 2005-08-30 : 10:39:41
|
| Are you useing .mdb or .adp ?JimUsers <> Logic |
 |
|
|
MattieBala69
Starting Member
30 Posts |
Posted - 2005-08-30 : 10:41:11
|
| .mdb |
|
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2005-08-30 : 13:19:27
|
| You'll have to write your own form that will have the pick list (and other parameter fields), and then call the query from the form.---------------------------EmeraldCityDomains.com |
|
|
|
JimL
SQL Slinging Yak Ranger
1537 Posts |
Posted - 2005-08-30 : 13:30:21
|
| You could do this using the pulldown for employee on a form and the start date and end date on a subform with the employee hidden.JimUsers <> Logic |
|
|
|
|
|
|
I need HELP