I am not sure what you mean, but could be only two things:
a) half page pulls the data from one query, and the rest
of the page pulls data from another query. If so, place
two subreports on your report, each based on its own
query.
b) same report layout, use qryA sometimes, and qryB some
other times. To do this, you may create a qryRepot, and
change its SQL before running the report. Of course, you
do this in code. Or, in reports OnOpen change the reports
recordset (underlying query)
Example:
Function SetUpReportsQry(strQryToUse as string) as boolean
'Purpose: set up SQL for the reports record source
'Assumed reports record source = aryReport
'Queries qryA and qryB may be used as report source for
the report
'Input parameter strQryToUse will be actual query
names, "qryA","qryB"
dim DB as database
dim qDef as querydef
set db=currentdb
set qdef = db.querydefs("qryRepot")
qdef.SQL = "SELECT * FROM " & strQryToUse
'Now your qryRepot pulls all the fields from
'Before calling your report, you run this function
end function
Example - Calling the report:
Function RunMyReport_A()
'Set up reports query:
SetUpReportsQry("qryA")
'Open teh report:
DoCmd.OpenReport MyReport
End Function
I have typed the code dirctly into the message so it may
be with typos. i hope you get the idea.
