Report with 2 sections based on different set of records

[Mihail]

Hello !
Is it possible to create a report with 2 sections based on different set of records ?
Say I have a table with only one field. This field can have only 2 different values: V1 and V2
I need to create a report with 2 "sections":
First (on top of paper) ALL records from the table (or only the records where field value is V1).
Second (on bottom of paper) all the records where field value is V2.

What about if the two sections are based on different tables ? Is it possible ? How ?

(ACCESS 2007)

Thank you !

[dsatino]

if it's one table, just create a group in the report based on the field that contains the two values.

if it's two tables:
you can either create a UNION query and base your report on that at which point you can create a group on the field.

or

create two reports and make one a sub report within the other. This is clumsier, but possible.

[Mihail]

Thank you for reply, dsatino.
I understand the idea but I am not sure I am enough skilled for that. I'll try. I think that to create two reports is easier for me. Thank you again.