Print Contact Cards

[Guest]

Hello -

I'm trying to print some labels from Acces that would produce a result like
this:

____________________________________________________________
| Name1 (W) xxx-xxxx (C) xxx-xxxx | Name1 (W) xxx-xxxx (C) xxx-xxxx |
| (H) xxx-xxxx (F) xxx-xxxx | (H) xxx-xxxx (F) xxx-xxxx
|
| Name2 (W) xxx-xxxx (C) xxx-xxxx |Name2 (W) xxx-xxxx (C) xxx-xxxx |
| (H) xxx-xxxx (F) xxx-xxxx | (H) xxx-xxxx (F) xxx-xxxx
|
| Name3 (W) xxx-xxxx (C) xxx-xxxx |Name3(W) xxx-xxxx (C) xxx-xxxx |
| (H) xxx-xxxx (F) xxx-xxxx | (H) xxx-xxxx (F) xxx-xxxx
|
| Name4 (W) xxx-xxxx (C) xxx-xxxx |Name4 (W) xxx-xxxx (C) xxx-xxxx |
| (H) xxx-xxxx (F) xxx-xxxx | (H) xxx-xxxx (F) xxx-xxxx
|
____________________________________________________________
| Name1 (W) xxx-xxxx (C) xxx-xxxx | Name1 (W) xxx-xxxx (C) xxx-xxxx |
| (H) xxx-xxxx (F) xxx-xxxx | (H) xxx-xxxx (F) xxx-xxxx
|
| Name2 (W) xxx-xxxx (C) xxx-xxxx |Name2 (W) xxx-xxxx (C) xxx-xxxx |
| (H) xxx-xxxx (F) xxx-xxxx | (H) xxx-xxxx (F) xxx-xxxx
|
| Name3 (W) xxx-xxxx (C) xxx-xxxx |Name3(W) xxx-xxxx (C) xxx-xxxx |
| (H) xxx-xxxx (F) xxx-xxxx | (H) xxx-xxxx (F) xxx-xxxx
|
| Name4 (W) xxx-xxxx (C) xxx-xxxx |Name4 (W) xxx-xxxx (C) xxx-xxxx |
| (H) xxx-xxxx (F) xxx-xxxx | (H) xxx-xxxx (F) xxx-xxxx
|____________________________________________________________
| Name1 (W) xxx-xxxx (C) xxx-xxxx | Name1 (W) xxx-xxxx (C) xxx-xxxx |
| (H) xxx-xxxx (F) xxx-xxxx | (H) xxx-xxxx (F) xxx-xxxx
|
| Name2 (W) xxx-xxxx (C) xxx-xxxx |Name2 (W) xxx-xxxx (C) xxx-xxxx |
| (H) xxx-xxxx (F) xxx-xxxx | (H) xxx-xxxx (F) xxx-xxxx
|
| Name3 (W) xxx-xxxx (C) xxx-xxxx |Name3(W) xxx-xxxx (C) xxx-xxxx |
| (H) xxx-xxxx (F) xxx-xxxx | (H) xxx-xxxx (F) xxx-xxxx
|
| Name4 (W) xxx-xxxx (C) xxx-xxxx |Name4 (W) xxx-xxxx (C) xxx-xxxx |
| (H) xxx-xxxx (F) xxx-xxxx | (H) xxx-xxxx (F) xxx-xxxx
|

....

is this possible?

/amelia

 

[Duane Hookom]

Apparently you want 6 copies of the same four records? What happens if you
have a 5th record?

You could create a table of numbers with a single numeric field
(tblNums.Num) and add records for 1-6. Create another table of letters with
a single text field (tblLetters.Letter) and add records for "A" and "B".

Add these tables to your reports record set and add their fields to the
grid. Set your report to print two columns. Set the sorting and grouping to:
tblNum.Num
NameField
tblLetters.Letter

 

[Guest]

thanks for your feedback, duane, but i've pretty much scrapped this
bothersome project.

back to the drawing board...

/amelia