Formatting Report as "business" cards - possible?

[tbaxter]

I have a membership database. I want to be able to print membership cards for each member using business card stock. Fields to be included would be:
1. concatenated field containing first and last name.
2. Member #
3. Membership Level

Any tips on the best way to do this, if it's even possible?

I need 10 different cards printing out on each sheet, not 10 copies of the same card or only 1 card per sheet.

Thanks in advance!

[This message has been edited by tbaxter (edited 01-29-2002).]

[This message has been edited by tbaxter (edited 01-29-2002).]

 

[tbaxter]

Doh! I can't believe I didn't think of that! LOL! Especially since I'm already using label wizard for the address labels!

Thanks, Pat.

[This message has been edited by tbaxter (edited 01-30-2002).]

 

[tbaxter]

Pat, I haven't printed them out yet but it looks like it'll work. My problem now is this:

I have the membership number as an autonum field (MemID) in the MemberID table (MemberID table contains MemID, Address, City, ST, Zip, Phone, e-mail, MemberLevel; I have a separate table for MemberDetail, which contains names and DoBs). The format for the MemID is "000000." For example, the 1st membership # is 000001 and it goes up from there (to a possible 999999 - I'll add more if we get more members than that).

The format shows up fine in the table, the queries, and the other reports. But, on the membership card, it only shows 1, 2, 3, etc., instead of 000001, 000002, 000003, etc.

Did I miss something somewhere? How can I fix this?

Thanks!

 

[tbaxter]

Never mind! I fixed it. Sometimes I need to try something before asking for help!

I deleted the field as the label wizard put it in (which was =[MemID]) and just put in the [MemID] field with a "Member Number" label in front of it.

All right - now to try the real test - printing them out!