Grouping records on the same line of a report

  • Thread starter Chuck Steenburgh
  • Start date
C

Chuck Steenburgh

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.
 
M

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.
 
C

Chuck Steenburgh

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...
 
D

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,....
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top