2 items in query, want them both to show up in heading

[Nate1749]

I'm using an external data source which puts our data in a csv file (NOT normalized). I have a query that does a group by and only pulls out unique names of the location. In this specific query there will only be 1 or 2 results, currently it's DuPage & Online. I am trying to make in the header of hte report have them both appear, but when I drag the item only the first one (Dupage) appears....

-Nate

 

[CosmoKramer]

Add an unbound text box to the report header and set its control source to something like this, changing for your field / query names:

=DMin("[Location]","YourQueryName") & " & " & DMax("[Location]","YourQueryName")

 

[Nate1749]

This works great if there are two schools, however, I have just learned that on occasion there will be 3; is there a DMiddle? or a DAll or something along those lines? Thanks...

-Nate