subreports that print horrizontally not in lists

[Qiana]

Hello<br>
I would like to know how can I manipulate a subform to print a specified number of records horrizontally accross. When this amount is reached then I will like it to roll under to the next line start to print vertically.<br>
EXAMPLE (this is what I don't want, but what I get for sub forms)<br>
<br>
(field titles)- Name TimeIn TimeOut Date<br>
Qiana 1:00 2:00 Jan 4, 1999<br>
Qiana 4:00 5:00 Jan 5, 1999<br>
Qiana 6:00 7:00 Jan 6,1999<br>
Qiana 7:00 8:00 Jan 7,1999<br>
<br>
EXAMPLE (this is what I do want?) Two records to a line<br>
(field titles)- Name TimeIn TimeOut Date Name TimeIn TimeOut Date<br>
Qiana 1:00 2:00 Jan 4, 1999 Qiana 4:00 5:00 Jan 5, 1999<br>
Qiana 6:00 7:00 Jan 6,1999 Qiana 8:00 9:00 Jan 7,1999

 

[DougP]

Are the items in different records?<br>
Qiana 1:00 2:00 Jan 4, 1999<br>
Qiana 4:00 5:00 Jan 5, 1999<br>
Qiana 6:00 7:00 Jan 6,1999<br>
Qiana 7:00 8:00 Jan 7,1999<br>
Each is on it's on line or in a separate record?<br>
<br>
If so then you can't do anything to force the form to work differently.<br>
But that doesn't mean you can't use code to loop thru records and then display then differently in a sub form.<br>
This will require a understanding how to move thru a recordset and parse out &quot;like&quot; items then write them back out in the order you want them and/or into new fields.<br>
<br>
What is your result here, a report? <br>
For ease of data entry?<br>
What??<br>
<br>
<br>
<br>

 

[elizabeth]

Not sure if this is what you are looking for but under Print Setup, you can define the report as having multiple columns, then specify that they fill horizontally. If I remember correctly this only takes care of printing the data horizontally; you may have to create header(s) and footer(s) to match - as in:<br>
Name Time In Time Out Name Time In Time Out Name Time In Time Out etc.