That was a good try, but the print preview and check print both just show the field names.
Mark On Wednesday 21 December 2005 11:28 pm, Naomi Kramer wrote: > OK, bleeding obvious and probably not worth asking... > > Did you try a print preview or sample print? Do the field names still > show instead? > > >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! > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] -- 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]
