max records returned

[nikos adamopoulos via AccessMonster.com]

I am using the TopValue property in order to limit the number of rows/records in my reports and tables.
I set the TopValue in the query property options.
I want to do the same, that is to limit the numbers of records, in a Union Query.
Does anybody have an idea how can this be done in a union query?

 

[JohnFol]

You could use the union as the input for a Select Top query . . . .

ie
Select top 10 * from MyUnionQuery

 

[Brian]

I am using the TopValue property in order to limit the number of

rows/records in my reports and tables.

I set the TopValue in the query property options.
I want to do the same, that is to limit the numbers of records, in a Union Query.
Does anybody have an idea how can this be done in a union query?

Save the union query, and then create another query that does SELECT TOP ??
<some fields> FROM <saved union query>

 

[nikos adamopoulos via AccessMonster.com]

IT WORKS. THANK YOU.