Multiple parameters on one page

  • Thread starter Thread starter STELL via AccessMonster.com
  • Start date Start date
S

STELL via AccessMonster.com

I have an inventory database that has a report which prompts me to enter the
FA number(s) that produces Form XXX. What I would like to do is to have the
FA numbers (along with selected fields in the record) produced in one page
instead of different pages. Can anybody help me with this?

This is what I currently have on the sql view that generates it into one or
more reports depending on the value inputted:
SELECT RoomIDs.ROOM_DESCRIPTION, RoomIDs.ROOM_ID, MyTableInventory.FA_NO,
MyTableInventory.BETT_NO, MyTableInventory.DESCRIPTION, MyTableInventory.MAKE,
MyTableInventory.MODEL, MyTableInventory.SERIAL_NO, MyTableInventory.ACQCOST,
MyTableInventory.PO_NO, MyTableInventory.RECD, MyTableInventory.SUBLOCATION,
MyTableInventory.FSC, MyTableInventory.EQ_TYPE, MyTableInventory.IBWC140
FROM Building INNER JOIN (RoomIDs INNER JOIN MyTableInventory ON RoomIDs.
ROOM_ID = MyTableInventory.ROOM_ID) ON Building.BLDG_CODE = RoomIDs.BLDG_CODE
WHERE InStr("," & [Enter FA number(s) separated by commas if more than one:]
& ",", "," & MyTableInventory.FA_NO & ",") > 0;
 
The page breaking in the report could be caused by a number of things, which
you'll need to examine in the report in design view:

1. Most likely is that the ForceNewPage property of a section is set to
'Before Section', 'After Section' or 'Before & After'. If so set it to
'None'. It could be the property of the Detail Section or a Group header or
footer.

2. A Page Break control has been added to one of the sections, probably at
the bottom of the section.

3. The design area of the detail section is such that it takes up a whole
page rather than being just deep enough to accommodate the controls. If so
resize it by dragging the bottom of the section up to just below the controls.

Ken Sheridan
Stafford, England
 
Back
Top