Print Record Multiple Times

[vich]

In my database I have a table consisting of scheduled activities(appointments) and each "activity" record has a field "Vehicle" that contains multiple ids (V1,V2,V3 etc.) for the record. It represents every Vehicle that is supposed to be at that appointment.

What I need to do is print the record multiple times on the report for each vehicle. I plan to sort by vehicle and appointment time so I am guessing it needs to be created somehow in the query.

Is there a better way of doing this besides creating a temporary table to hold individual records for each vehicle on an activity record.

Any help or direction is appreciated.

 

[dhookom]

Don't store multiple values in a single field. Create a related table with multiple records per activity.

If you can't do that, you can create a query that returns multiple records if your vehicle numbers are all unique and entry is consistant.

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]

 

[vich]

Thats what I am hoping to figure out. I am not sure how to do that.

I know it is not the best design. It is infrequent that there is more than one vehicle on a record but it does occur. The names are consistant and unique because they are added to the text field through a form with a list to select from.

I am trying to create a query with functions that count the number of Vehicles on a record and somehow output multiple records but haven't figured that out yet. Any examples would be greatly appreciated.

 

[ProgramError]

I was sing a similar idea for printing dvd and vhs labels where it would prin off a quanty of the labels dependng on a query.

You may find the two following threads useful.

http://www.tek-tips.com/viewthread.cfm?qid=1029088&page=1

]

http://www.tek-tips.com/viewthread.cfm?qid=1036421&page=1

]

Program Error
Programmers do it one finger at a time!