One Row of a Query

W

williamr

I have a query that gives me some totals. Can I use only 1 of those lines in
a text box? I tried using the expression builder but don't see where I can
select just 1 line.

Thanks in advance
Wm.
 
K

KARL DEWEY

I am missing something. A text box will only display on record at a time.

If it is giving you five records then how will you distinguish which of the
five that you what. Use that information as criteria.
 
W

williamr

Yes, I get 9 rows of information which is correct but I want to put row 2 on
a tab, row 8 on a tab and the rest on the 3rd tab. So I guess I'm asking,
do I have to create 3 queries?
 
K

KARL DEWEY

I guess so, I am a loss for what you are doing.

williamr said:
Yes, I get 9 rows of information which is correct but I want to put row 2 on
a tab, row 8 on a tab and the rest on the 3rd tab. So I guess I'm asking,
do I have to create 3 queries?
Click to expand...
 
Top