Grouping records on the same line of a report

[Guest]

I have been unable to figure out how to group records on the SAME LINE of a
report. All Access seems to be able to comprehend is a COLUMN of data. I'd
love to have a report with a grouping level that lists fields in a single row
separated by commas. Ya know, plain English!

Record1, Record2, Record 3

Not

Record1
Record2
Record3

I was able to do this back in the DOS/dBase era but can't figure out how to
do this in Access for the life of me.

 

[Marshall Barton]

"Chuck Steenburgh" <Chuck

I have been unable to figure out how to group records on the SAME LINE of a
report. All Access seems to be able to comprehend is a COLUMN of data. I'd
love to have a report with a grouping level that lists fields in a single row
separated by commas. Ya know, plain English!

Record1, Record2, Record 3

Not

Record1
Record2
Record3

You need to create a function to do that. There's several
of them out there on the web. Duane's Concatenate function
at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane
is a popular one.

 

[Duane Hookom]

There is a generic concatenate function that will do this at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane.

 

[Guest]

Thanks to both of you. I'll give this function a try.

Whatever happened to the old PRINT " "; from BASIC? Ah, the good old
days...

 

[Duane Hookom]

Reports to allow you to use code in a Format or Print event like:

Me.Print "Hello World"

You can set the X and Y coordinates prior to printing with code like:
Me.CurrentX = 1440 'one inch from left margin
Me.CurrentY = 144 'tenth of inch from top

There are also Line and Circle methods that allow drawing lines, rectangles,
arcs, circles, ovals,....