Is Access report the right tool here?

[simonwait]

Hi.



I manage a small football (soccer) club and we have all player info in Access which i use to create various documents. This yeah part of the process is that we have to download a squad list of our players. This list shows little frames with the player details in. The trouble is that each time this list is produced the order of the players seems randomised. On this list we then have to stamp each player with a unique player league code. We have the player name, team and league code already in a table and so my thought was to just do a report and maybe add a couple of fields in the table which show which column and row they are on list. (The lists are 2 columns and depending on team size could be 5 rows or up to 10).

I created a report with the field of the league number but im not sure if can dictate very easily which box the data goes in for a particular player. I get the feeling I'm going to have to go down the VBA route but just wondering if there is a better way of doing this. Ideally i would like to keep this within Access purely because everything else is but if sending things to word, excel or even say publisher is better then they are options. Attached is a crude sketch of what we are doing.



Many thanks in advance for your thoughts on the best way to approach this.

[Welshgasman]

You do know that you have to specify the sort order in the report?
You can specify number of columns in a report very easily.
You can put that data on another line using Chr(13) & Chr(10)
Would need to use a Tab character as well or several spaces.

Not sure how you would surround it with a box though.

You can put another textbox over a textbox and format that with a border. However then I lose the 2 columns for some reason. However that is only in report view.

[June7]

Your mockup shows players listed in numerical order snaking right then down except for Jane - why? What rule applies? If league code does not dictate order then you will need another field in table to do that. I have built reports with unusual sort requirements and yes, VBA is involved.

AFAIK, multi-column does not display in ReportView at all, only PrintPreview or direct to printer.
Textbox as border works but could use a Rectangle control to surround other controls with a border. In either case, could position it behind others with right click >Position >SendToBack. BackStyle can be set transparent.

[Welshgasman]

AFAIK, multi-column does not display in ReportView at all.

Yes, I found that out. I do not play around much with reports.

[mike60smart]

Hi
Are you able to upload a copy of the database?

[jojowhite]

you can create a Two-Column report that is Sorted by LeageNumber.
see samplereport report on the demo.