Capture a criteria value

[Guest]

Probably this has been answered somewhere else, if so, please indicate me
where I can find the notes.

This is my issue:

I have a table with users who may work in up to 3 different buildings.
I also have a report based on a query which is also based on input by
building name.

Here is the example of the query:

SELECT [TBl-EmployeesData].LastName, [TBl-EmployeesData].FirstName,
[TBl-EmployeesData].Building1, [TBl-EmployeesData].Building2,
[TBl-EmployeesData].Building3
FROM [TBl-EmployeesData]
WHERE ((([Building1] & "," & [Building2] & "," & [Building3]) Like "*" &
[Enter Building Name] & "*"))
ORDER BY [TBl-EmployeesData].LastName;


Question:
How do I capture the value input from the query's criteria [Enter Building
Name] and use it , let’s say, as the page header information on a report?

 

[Marshall Barton]

Probably this has been answered somewhere else, if so, please indicate me
where I can find the notes.

This is my issue:

I have a table with users who may work in up to 3 different buildings.
I also have a report based on a query which is also based on input by
building name.

Here is the example of the query:

SELECT [TBl-EmployeesData].LastName, [TBl-EmployeesData].FirstName,
[TBl-EmployeesData].Building1, [TBl-EmployeesData].Building2,
[TBl-EmployeesData].Building3
FROM [TBl-EmployeesData]
WHERE ((([Building1] & "," & [Building2] & "," & [Building3]) Like "*" &
[Enter Building Name] & "*"))
ORDER BY [TBl-EmployeesData].LastName;


Question:
How do I capture the value input from the query's criteria [Enter Building
Name] and use it , let’s say, as the page header information on a report?

Set the page header text box's control source to **exactly**
the same prompt string.

 

[Guest]

Thanks,
That did it!

Jose DeSousa

Probably this has been answered somewhere else, if so, please indicate me
where I can find the notes.

This is my issue:

I have a table with users who may work in up to 3 different buildings.
I also have a report based on a query which is also based on input by
building name.

Here is the example of the query:

SELECT [TBl-EmployeesData].LastName, [TBl-EmployeesData].FirstName,
[TBl-EmployeesData].Building1, [TBl-EmployeesData].Building2,
[TBl-EmployeesData].Building3
FROM [TBl-EmployeesData]
WHERE ((([Building1] & "," & [Building2] & "," & [Building3]) Like "*" &
[Enter Building Name] & "*"))
ORDER BY [TBl-EmployeesData].LastName;


Question:
How do I capture the value input from the query's criteria [Enter Building
Name] and use it , let’s say, as the page header information on a report?

Set the page header text box's control source to **exactly**
the same prompt string.