O
Oldsfan
Hi. I don't know if I can explain what I'm trying to do. Maybe I'm over my
head.
I've got a car club database. One table is name/address information. Another
table is year/make/model information. The third is the joining table, putting
members and cars together. Some members have no cars. Some members have more
than one.
I am trying to print a roster in Word, listing name/address/cars owned.
When I run my "directory" query, I get, for myself as an example:
Paul H, address, phone, 55 Olds
Paul H, address, phone, 62 Olds
When I pull this over to word, it looks like this:
Paul H
address
phone
55 Olds
Paul H
address
phone
62 Olds
Is there a way to get it to look like this?:
Paul H
address
phone
55 Olds
62 Olds
I tried running my "Directory" query with a "Vehicles Owned" subdatasheet.
My query results look like this:
Paul H, address, phone
+55 Olds
+62 Olds
But Word won't pick up the data from the subdatasheet.
I end up having to manually deleting all the duplicate name/address
information in Word. This is time consuming - some people have a dozen or
more cars!
Or should I be addressing this on the Word forums?
head.
I've got a car club database. One table is name/address information. Another
table is year/make/model information. The third is the joining table, putting
members and cars together. Some members have no cars. Some members have more
than one.
I am trying to print a roster in Word, listing name/address/cars owned.
When I run my "directory" query, I get, for myself as an example:
Paul H, address, phone, 55 Olds
Paul H, address, phone, 62 Olds
When I pull this over to word, it looks like this:
Paul H
address
phone
55 Olds
Paul H
address
phone
62 Olds
Is there a way to get it to look like this?:
Paul H
address
phone
55 Olds
62 Olds
I tried running my "Directory" query with a "Vehicles Owned" subdatasheet.
My query results look like this:
Paul H, address, phone
+55 Olds
+62 Olds
But Word won't pick up the data from the subdatasheet.
I end up having to manually deleting all the duplicate name/address
information in Word. This is time consuming - some people have a dozen or
more cars!
Or should I be addressing this on the Word forums?