Add New Rows Depending on An Entered Value

[Bridiewms]

I have been told my problem may be able to be resolved using a query....

I have a form where we fill in information for supply of PPE to employees.

Each item must be signed for on a printed report.

I am encountering problems trying to create enough rows for my report detail for each signature of the number of items supplied.

For example, on the form I will select the "equipment" - 4 hats supplied and 3 boots. On the report I want the equipment set as the group and the detail to be a number or rows which equals the number of selected items. therefore under the Hats group heading I want 4 blank rows which are made up of 3 text boxes - Print Name, Signature & Date and another group heading for boots but with 3 lines.

Any chance you can explain using my data...

The Query gives the results below: (Item name is linked to a PPE table containing Item ID, Item Name, Cost etc..)

IssueID DateProvided Item_Name AmountIssued
0001 01/11/2013 Gloves (Orange) 10
0001 01/11/2013 Hard Hats (Black) 2
0002 02/11/2013 Hi Viz (Large) 5

The report I aim to generate from this should look as attached - Please excuse my drawing!

The query/report is set up as a parameter report so I will enter the issueID such as 0001 and only those items will appear on the report to print and sign.

Please could you provide me with as much information as possible in regards to how to achieve this via a query, I am struggling to put something together.

Thank You

 

[namliam]

Cant do this in a query, but can force this in a report.

Simply force the report to generate a new page on a group (or row in your case) and your done

 

[Bridiewms]

Is there some coding to do this? I have tried several different types of coding but nothing seems to be working.

Really struggling to get a resolution to this.

 

[namliam]

Make a table that has your 3 columns (or however many you need) and a primary key with numbers 1 thru how ever many you need.

Then you can use a sub-report or sub-form that you join to this table using a where:
ID <= NumberOfItems

This will create your "Dummy" lines.

 

[Bridiewms]

http://www.access-programmers.co.uk/forums/showthread.php?t=256295

This thread solves the issues.