Create New Table with unique customer rows

[jstopper]

I am trying to take a table that looks like this:

Customer Name	Fruit
Customer A	Apples
Customer A	Bananas
Customer B	Pears
Customer B	Apples
Customer C	Pears

and create a table that looks like this:

Customer Name	Apples	Bananas	Pears
Customer A	Apples	Bananas
Customer B	Apples		Pears
Customer C			Pears

I think this is relatively simple but don't know the syntax to create this table. Can anyone help?

[June7]

How many different fruits are there? Review http://www.datapigtechnologies.com/f.../crosstab.html

Otherwise, what you want is not easily done. A conventional CROSSTAB query requires 3 fields.

[orange]

Your proposed structure looks like a spreadsheet. If you really want to use a database (Access) to store and retrieve your data you should learn more about database and how it differs from spreadsheet.
Here is a tutorial about designing a database.

Good luck.