Report combine records on number 1

[jacko999]

On a report im creating i want two records from the same field combining onto my report if they have the same lesson number. I dont have a clue how to do this so any help would be appreciated.

Chris

 

[dhookom]

I'm afraid you question doesn't make much sense. Could you provide some significant table and field information as well as sample records and how you want them to appear on your report?

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[lespaul]

SOunds like he wants to concatenate records, maybe look at FAQ701-4233

Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual

Essential reading for database developers:
The Fundamentals of Relational Database Design
Understanding SQL Joins