parameter of a query

  • Thread starter Thread starter giannis
  • Start date Start date
G

giannis

I have make a query that ask a parameter (for criteria).
This query opens a form with criteria this parameter.
I need a label in this form that says the criteria (=parameter).
How can store the parameter of query in this label ?
 
Put the parameter in the query as a field. For example, try his in NWind

SELECT Employees.EmployeeID, [EnterEmployeeID] AS EnteredParameter,
Employees.LastName, Employees.FirstName
FROM Employees
WHERE ((([EnterEmployeeID])=[employeeid]));

You now have a field called "EnteredParameter" available to display on the
form
 
Thank you !!!
I didnt know the word "AS" in SQL .
JohnFol said:
Put the parameter in the query as a field. For example, try his in NWind

SELECT Employees.EmployeeID, [EnterEmployeeID] AS EnteredParameter,
Employees.LastName, Employees.FirstName
FROM Employees
WHERE ((([EnterEmployeeID])=[employeeid]));

You now have a field called "EnteredParameter" available to display on the
form



giannis said:
I have make a query that ask a parameter (for criteria).
This query opens a form with criteria this parameter.
I need a label in this form that says the criteria (=parameter).
How can store the parameter of query in this label ?
Click to expand...
Click to expand...
 
Back
Top