Sue
You're not able to do that in a query. Even if you used a cross tab query you can only put one field to return values across the row.
If the Access back end is available to you you could create a report there provided it isn't too locked down. Or you could create an Access front end and link to the tables and make your report in the front end.
An Access report will give you the ability to use a group header to show the customer info and then the detail would be the pet stuff. Or you could use a report for the customer stuff and a sub report for the pet stuff.
Regards,
Bill Mosca, Founder - MS_Access_Professionals
http://www.thatlldoit.com
Microsoft Office Access MVP
http://mvp.microsoft.com/en-us/mvp/Bill%20Mosca-35852
My nothing-to-do-with-Access blog
http://wrmosca.wordpress.com
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (2) |
Tidak ada komentar:
Posting Komentar