Display data

[Bee]

Hi,

I am using a query to print information about customers and products on a report; the query is returning something like this:

Customer---------------------Products
cust1-------------------------------apple
cust1-------------------------------cereal
cust1-------------------------------salad
cust2-------------------------------photos
cust2-------------------------------bananas
However, my client is wanting all the info about each customer displayed in list like this:

Customer----------------------Products
cust1--------------------------------apple------------------cereal-------------------salad
cust2--------------------------------photos-----------------bananas

I can change my tables to reflect product1...productn, but that will break database rules.

Any suggestions please?

Regards,
B

 

[Ron_dK]

You might take a look at this thread :

http://www.access-programmers.co.uk/forums/showthread.php?t=106426&highlight=wayne

Hth

 

[Bee]

You might take a look at this thread :

http://www.access-programmers.co.uk/forums/showthread.php?t=106426&highlight=wayne

Hth

rak,

Thank you for your help. I could not get that code to work for me. I wonder if you have got an example please?

Cheers,
B

 

[Bee]

Any help with this thread will be very much appreciated. I am still stuck.

 

[CraigDolphin]

Would you be able to use a crosstab query to achieve something similar?

Customer-------------Products----------CountOfProducts
Row Source--------Column Source-------Value

Customer_____Apples___Bananas___Cereal
X_____________1_________0________0
Y_____________1_________1________0
Z_____________0_________0________1

Also, I noticed in the other thread you had some question about recordsets, maybe you might find this tutorial helpful. It certainly helped me.
http://www.devdos.com/vb/lesson4.shtml

 

[Rich]

ArticleID: Q141624

 

[Ron_dK]

I wonder if you have got an example please?

Cheers,
B

See attached.
Hope that helps.

 

[Bee]

See attached.
Hope that helps.

That helped. Thank you.