Should be a simple report, but I can't figure it out

[mattmickle]

I'd like to create a "roster" report from my database, listing every active record.
It would be used as a "sign-in sheet", so I'm looking to create a report (pulling 3 fields - Last Name, First Name, Status) that look like the following:

Ames, Jonathan (A) _____________ Hayes, Darren (A) _________________
Brown, Chris (S) _______________ Harris, Michael (AH) _________________

etc, etc.

I've got the query built, but can't figure out how to "concatenate" the three fields, add the sign-in lines, etc.
Any help would be greatly appreciated!

Matt

 

[welshgasman]

http://www.databasedev.co.uk/multi-column_report.html

https://www.google.com/search?q=two...i57j0j69i64.8161j0j7&sourceid=chrome&ie=UTF-8

 

[mattmickle]

welsgasman,
Thanks! that got me right where i needed to go. a little tweaking, a little experimentation, and I have my report. thanks again!