I set up a mysql database with address information. I want to create some mailing labels. However, every time I set them up, all I get is the database fields in the labels and not the data. (Openoffice 2.0 on Linux).
This is what I did: 1. Created two tables in a mysql database - one with the names/addresses and one with the dates I have mailed to them. These two tables are linked by a name_id field. 2. In Base I created a query that selects the data from the names table based on a criteria in the other table. I tested the query and it works in the design view. Something like - SELECT * FROM Names, Sent WHERE Names.name_id=Sent.name_id AND Sent.year=2005 3. I selected new from the file menu and then labels. 4. I selected the database, table, and fields for the label, then selected new document. All I get in the labels are the names of the fields and not the data from the table. Any suggestions would be greatly appreciated. Oh, BTW I am not an evil junk mail marketer - this little project is for my wife to keep track of her Christmas card mailing! Thanks! -- Mark Phillips Phillips Marketing, Inc [EMAIL PROTECTED] 602 524-0376 480 945-9197 fax --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
