Solved Trying to figure out how to start new column in a report after a given amount of records

[eibyer_apc]

I have a query that generates records from 100 to 140. I'd like to distribute the printout into 3 columns. I got as far as getting my result count into a variable but am not sure how to start the new column when my desired number of records for the first column is reached.

I'm more comfortable in Excel, just getting my feet wet in Access

Thank you!

 

[Uncle Gizmo]

I'd like to distribute the printout into 3 columns.

Have a look at weaving records in a report:-

Reports Weaving Records – Nifty Access

www.niftyaccess.com

 

[GPGeorge]

I have a query that generates records from 100 to 140. I'd like to distribute the printout into 3 columns. I got as far as getting my result count into a variable but am not sure how to start the new column when my desired number of records for the first column is reached.

I'm more comfortable in Excel, just getting my feet wet in Access

Thank you!

I think there's more to the question that appears on the surface.

First, for example, the title of the post, is "Trying to figure out how to start new column in form...." Forms are on-screen only, and not intended to be printed out, even though it's possible to do so. Reports are, on the other hand, designed to be printed out, but can be displayed on-screen. So it's important to know what exactly the problem is. Are you actually trying to print out a form? Or are you talking about creating a report to print?

Second, columns are one of the features of reports, but not of forms. So it's a moot point if, in fact, you really do mean forms.

That said, you could embed a report with columns as a subform in a subform control in a form, if that would meet the requirement.

So, can we clarify what's going on? Thanks.

 

[eibyer_apc]

My bad, you got me, see I told you I was a newbie. I meant report, not form! Let me see if I can edit the thread title.

Edit: Also, I believe this thread should be moved to the appropriate section also.

 

[MajP]

This may help

Multiple Column Reports in Microsoft Access | Database Solutions for Microsoft Access

Creating a Multiple-Column Report in Microsoft Access: There may be the time where you need to arrange data into multiple columns in your Microsoft Access reports. There will have been times where you have needed to deal with the issues of trying to squeeze all of the fields for an Access...

www.databasedev.co.uk

 

[theDBguy]

Edit: Also, I believe this thread should be moved to the appropriate section also.

Hi. Welcome to AWF!

As requested, I moved your thread to the Reports forum. Good luck!

 

[SHANEMAC51]

I'd like to distribute the printout into 3 columns.

I would like to decompose the printout into 3 columns.
1 - if the elements are placed horizontally, a standard report is sufficient, without code (Fig. 1)
2 - if vertically, then you will have to write program code (Fig. 2)

 

[eibyer_apc]

I would like to decompose the printout into 3 columns.
1 - if the elements are placed horizontally, a standard report is sufficient, without code (Fig. 1)
2 - if vertically, then you will have to write program code (Fig. 2)

@SHANEMAC51, figure 2 is what I'm after so I'm definitely going to have to code something together.

 

[SHANEMAC51]

figure 2 is what I'm after so I'm definitely going to have to code something together.

lay out an example of a database with a report in 1 column , I need to understand if it differs from mine
3-4 record

 

[eibyer_apc]

I am not sure if we're allowed to upload a sample db (I didn't search yet) so I just clipped it.

This table may grow up to about 160ish in record count. What I'm trying to accomplish is to divide it into 3 columns. In this example, the query would have 19 records so I'll end up with 2 columns of 6 records each and the third column with 7.

Am I looking for some kind of event that checks what record number was last entered in the report so I can start the next column if that record was number 6. I hope that made sense. Thanks for looking!

 

[MajP]

That said, you could embed a report with columns as a subform in a subform control in a form, if that would meet the requirement.

As said the vertical solution will require code. Horizontal does not.
That is one way to do it. Maybe there is an easier way. If you had three subforms to look like columns then.
1. Determine number of records
2. Divide by 3 to get N and get remainder R
3. Update three query definitions (Pseudo code)
Q1: Select Top N ContactName from table1Order By ContactName
Q2: Select Top N ContactName from Table1 where ID Not in (Select Top N ID from Table1 Order By ContactName) Order by ContactName
Q3: Select Top (N+R) ContactName from table1 Where ID Not In (Select top (2N) ID from Table1 Order By ContactName) Order By ContactName
4. Set the source objects of the three subforms.

The Other way is a TempTable. For me this is a lot easier
The Temp table has three Columns. C1, C2, C3
1. Determine number of records
2. Divide by 3 to get N
3. Write to the TempTable. After each N record start on the next column. For the last column put all remaining records

This works fine until you exceed what can go on one sheet.

 

[eibyer_apc]

Thank you for this, let me see what I can put together using your suggestion.

 

[SHANEMAC51]

I have a query that generates records from 100 to 140

using an example of 137 rows, adding a service field to the table for grouping, taking into account the possible extension = yes, I got an option with setting the number of records in the column

 

[SHANEMAC51]

I have a query that generates records from 100 to 140

137 entries in font 8 fits into the page,

it is necessary to somehow still try students by classes in 3 columns, although this can apparently be implemented without an additional field, since there are clearly less than 100 people in the class (obviously it will fit into the page)

 

[SHANEMAC51]

although this can apparently be implemented without an additional field, since there are clearly less than 100 people in the class (obviously it will fit into the page)

 

[arnelgp]

simple division by 3 the total records
and using temporary table.

 

[SHANEMAC51]

simple division by 3 the total records
and using temporary table.

I think that the records should be sorted
sheet 1 - 150 minimum, 3 columns from top to bottom
sheet 2 - the next 150
last sheet - the remainder, for example 3 columns of 10-11 values

moreover, the values can be longer than 10-12 characters, 150 last name + first name may not fit on the sheet

 

[arnelgp]

this is sorted.
what more can you ask?

 

[eibyer_apc]

Woah, lots of activity to sort out. I appreciate it guys/gals, this will take me a bit to digest. Thank you!

 

[arnelgp]

this is report of sample names.