One Row of a Query

[Guest]

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.

 

[Guest]

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.

 

[Guest]

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?

 

[Guest]

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

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?