J
Jack at ArcLight
I have two reports: One that displays Investment information (potential
aquisitions) that are being reviewed by an investment comittee, and another
report (potential aquisitions) that are not currently being reviewed.
The first report contains no more than 4 items, and rarely takes up 1/2 a page
the second report can be up to 4 pages long.
all of the colums between the reports are identical, and the data in my
queries is pulled from the same table. The only difference is in the first
query i am filtering by a review status field, which also allows me to
include a field marked dead.
here is the sql string for the query used in the first report:
SELECT tblDeals.DealID, tblDeals.DealName, tblDeals.Sponsor,
tblDeals.Partner, tblDeals.Rating, tblDeals.InvestmentSizeMin,
tblDeals.InvestmentSizeMax, tblDeals.DateIn, tblDeals.ExpectedClose,
tblDeals.Comments, Concatenate("SELECT Initials FROM queryEEDealDates WHERE
EEDealName =" & [DealID]) AS Team, tblDeals.Tier, tblDeals.ReviewStatus,
tblDeals.Status
FROM tblDeals
WHERE (((tblDeals.Status)="Dead") OR ((tblDeals.Status)="Active")) AND
(((tblDeals.ReviewStatus)="IC Review") OR ((tblDeals.ReviewStatus)="2P
Review"));
The dead field is being filtered in the second query as i do not want to
show any potential investments with that designation. Here is the sql string
for the query used in the second report:
SELECT tblDeals.DealID, tblDeals.DealName, tblDeals.Sponsor,
tblDeals.Partner, tblDeals.Rating, tblDeals.InvestmentSizeMin,
tblDeals.InvestmentSizeMax, tblDeals.DateIn, tblDeals.ExpectedClose,
tblDeals.Comments, Concatenate("SELECT Initials FROM queryEEDealDates WHERE
EEDealName =" & [DealID]) AS Team, tblDeals.Tier, tblDeals.Status,
tblDeals.ReviewStatus
FROM tblDeals
WHERE (((tblDeals.Status)="Active") And ((tblDeals.ReviewStatus) Is Null));
I want to have the second report begin on the bottom half of the page of the
first report. I have tried dragging it in design view, but when going to
print, a page break is automatically inserted between the reports. Any help
would be great. Thanks.
aquisitions) that are being reviewed by an investment comittee, and another
report (potential aquisitions) that are not currently being reviewed.
The first report contains no more than 4 items, and rarely takes up 1/2 a page
the second report can be up to 4 pages long.
all of the colums between the reports are identical, and the data in my
queries is pulled from the same table. The only difference is in the first
query i am filtering by a review status field, which also allows me to
include a field marked dead.
here is the sql string for the query used in the first report:
SELECT tblDeals.DealID, tblDeals.DealName, tblDeals.Sponsor,
tblDeals.Partner, tblDeals.Rating, tblDeals.InvestmentSizeMin,
tblDeals.InvestmentSizeMax, tblDeals.DateIn, tblDeals.ExpectedClose,
tblDeals.Comments, Concatenate("SELECT Initials FROM queryEEDealDates WHERE
EEDealName =" & [DealID]) AS Team, tblDeals.Tier, tblDeals.ReviewStatus,
tblDeals.Status
FROM tblDeals
WHERE (((tblDeals.Status)="Dead") OR ((tblDeals.Status)="Active")) AND
(((tblDeals.ReviewStatus)="IC Review") OR ((tblDeals.ReviewStatus)="2P
Review"));
The dead field is being filtered in the second query as i do not want to
show any potential investments with that designation. Here is the sql string
for the query used in the second report:
SELECT tblDeals.DealID, tblDeals.DealName, tblDeals.Sponsor,
tblDeals.Partner, tblDeals.Rating, tblDeals.InvestmentSizeMin,
tblDeals.InvestmentSizeMax, tblDeals.DateIn, tblDeals.ExpectedClose,
tblDeals.Comments, Concatenate("SELECT Initials FROM queryEEDealDates WHERE
EEDealName =" & [DealID]) AS Team, tblDeals.Tier, tblDeals.Status,
tblDeals.ReviewStatus
FROM tblDeals
WHERE (((tblDeals.Status)="Active") And ((tblDeals.ReviewStatus) Is Null));
I want to have the second report begin on the bottom half of the page of the
first report. I have tried dragging it in design view, but when going to
print, a page break is automatically inserted between the reports. Any help
would be great. Thanks.