Dlookup

[Guest]

I am trying to use multiple text boxes in a report using something similiar
to a DLookup function to return up to 10 different items in the same field.
The only functions I am aware of are DLookup, DFirst and DLast. Is there a
function which allows me to choose the "middle" values from what DFirst and
DLast would provide? Thanks.

 

[Rick Brandt]

I am trying to use multiple text boxes in a report using something
similiar to a DLookup function to return up to 10 different items in
the same field. The only functions I am aware of are DLookup, DFirst
and DLast. Is there a function which allows me to choose the "middle"
values from what DFirst and DLast would provide? Thanks.

Sounds like you need a subreport.