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]
