Formatting Report Layout 1

[bulldawg15]

I was wondering if there is any way to format a report to look more like a text document than columns? Here's what I'm talking about.
I'm doing a racing database and I need the following fields on the report: Class_ID, Heat, Rank, Car_Number, Driver_Name, Address. I have a Rank table that tracks the Class_ID, Heat, Rank, and Car_Number that links to the Driver information table.

Here is how I want the report to look:

Hobby Stocks

A-Feature: Rank, Car_Number, Driver_Name, Address; Rank, Car_Number, Driver_Name, Address; Rank, Car_Number, Driver_Name, Address; Rank, Car_Number, Driver_Name, Address;

B-Feature: Rank, Car_Number, Driver_Name, Address; Rank, Car_Number, Driver_Name, Address; Rank, Car_Number, Driver_Name, Address; Rank, Car_Number, Driver_Name, Address;

Late Models

A-Feature: Rank, Car_Number, Driver_Name, Address; Rank, Car_Number, Driver_Name, Address; Rank, Car_Number, Driver_Name, Address; Rank, Car_Number, Driver_Name, Address;

B-Feature: Rank, Car_Number, Driver_Name, Address; Rank, Car_Number, Driver_Name, Address; Rank, Car_Number, Driver_Name, Address; Rank, Car_Number, Driver_Name, Address;

And so on and so forth. Is this possible in any way shape or form? Thanks in advance.

 

[rssql]

When you have a report open in design view,
click "View", then "Sorting and Grouping".

the field that contains "Hobby Stocks" and "Late Models" would be the field that is seleted in the "Sorting and Grouping".

The reports' Detail section is where you put the fields for "A-Feature: Rank, Car_Number, Driver_Name, Address; Rank, Car_Number, Driver_Name, Address; Rank, Car_Number, Driver_Name, Address; Rank, Car_Number, Driver_Name, Address;
".


Is that enough?

 

[bulldawg15]

Thanks for the reply. I understand all of that but what I want to know is can I have new records inserted on the same line and then word wrap at the end of the page instead of starting a new row for each record? Thanks.

 

[rssql]

how's this?
have one BIG textbox where ControlSource =
MyFeature & ":" & Rank & ", " & Car_Number & ", " & .......

if you have spaces inside some of the fields, you may want to do this:

Trim(MyFeature) & ":" & Trim(Rank) & ", " & Trim(Car_Number) & ", " & .......

 

[bulldawg15]

rssql,

Thanks for your continuing help. You are definitely on the right track now. The only thing is that I need this to be dynamic as it will be unknown how many entries there will be depending on how many drivers there are on a certain night. The end result needs to look like:

Hobby Stocks

A-Feature: 1. 20 John Doe, Miami; 2. 92 Jeff Ode, Atlanta; 3. 8 Bill Doe, Houston; 4. 13 Joe Blow, Dallas; 5. 99 TJ Doe, San Francisco

B-Feature: 1. 20 John Doe, Miami; 2. 92 Jeff Ode, Atlanta; 3. 8 Bill Doe, Houston; 4. 13 Joe Blow, Dallas; 5. 99 TJ Doe, San Francisco

Late Models

A-Feature: 1. 20 John Doe, Miami; 2. 92 Jeff Ode, Atlanta; 3. 8 Bill Doe, Houston; 4. 13 Joe Blow, Dallas; 5. 99 TJ Doe, San Francisco

B-Feature: 1. 20 John Doe, Miami; 2. 92 Jeff Ode, Atlanta; 3. 8 Bill Doe, Houston; 4. 13 Joe Blow, Dallas; 5. 99 TJ Doe, San Francisco


Obviously there wouldn't be the same people racing in multiple Classes and having the same rankings twice but I just copied/pasted to save me typing and name creating time. Each night there are a different number of drivers and could be up to about 30 on a night. Is there some way I can accomplish this through a loop of some sort? Thanks again for your help. Greatly appreciated!

 

[bulldawg15]

I did some surfing and found this thread on the site. It sounds like it may be what I'm looking for except it doesn't run correctly for me. I'm running into the same problem that Sera was having of it asking for like a criteria value upon running the report. I thought maybe someone else would understand this better or have a copy of that module somewhere. Thanks.

 

[bulldawg15]

I ended up getting this code to run correctly so I should be good to go now. Thanks for the postings.