Shippwreck
Programmer
I'm using Access 2002 and when i run the query below it brings up a little box to enter the argument.
SELECT DISTINCT COUNT(Admin) AS [Admin Count No]
FROM [Event Applicants]
WHERE [NHS Trust]=[Name of Trust];
for this to work the user must know exactly how the field appears in the table. I was wondering if there was a way of turning this box into a drop down box. If that is possible could i go one step further and use a different table to provide the arguments for the drop down box.
any ideas would be good,
thanks
SELECT DISTINCT COUNT(Admin) AS [Admin Count No]
FROM [Event Applicants]
WHERE [NHS Trust]=[Name of Trust];
for this to work the user must know exactly how the field appears in the table. I was wondering if there was a way of turning this box into a drop down box. If that is possible could i go one step further and use a different table to provide the arguments for the drop down box.
any ideas would be good,
thanks