How to Use Expression Builder to display Query Results?

Hi,
I have a report with a text box in it. I'm trying to use the Expression
Builder to display the result of a query in this textbox. Let me explain:
returns the list of users that have certain access to information where I
work. So the query result has check boxes similar to this:

Name(field) Access Type(field)
name checkbox=true
name checkbox=true

In my report the text box(from above) is underneath the access type field :

Access Type(field)
User Name: textbox

What I'm trying to do is somehow use the expression builder to display all
the names that have checkbox=true in the textbox on the report like so:

AccessTyep(field)
----------------
| name |
| name |
| name |
----------------

Is there a way to use the expression builder to somehow loop through the
records from the query and input the names line after line in the text box?

Let me know if this is not clear.....

Thank you,
Alex

You won't get this from the expression builder. You could try a subreport or
possibly the generic concatenate function found at
http://www.rogersaccesslibrary.com/O...p#Hookom,Duane.
--
Duane Hookom
Microsoft Access MVP


"Alex" wrote:

Hi,
I have a report with a text box in it. I'm trying to use the Expression
Builder to display the result of a query in this textbox. Let me explain:
returns the list of users that have certain access to information where I
work. So the query result has check boxes similar to this:

Name(field) Access Type(field)
name checkbox=true
name checkbox=true

In my report the text box(from above) is underneath the access type field :

Access Type(field)
User Name: textbox

What I'm trying to do is somehow use the expression builder to display all
the names that have checkbox=true in the textbox on the report like so:

AccessTyep(field)
----------------
| name |
| name |
| name |
----------------

Is there a way to use the expression builder to somehow loop through the
records from the query and input the names line after line in the text box?

Let me know if this is not clear.....

Thank you,
Alex