Search for data in a table

[JennieFernandes]

I have a table with the following information: "PersonName", "PurchaseQuantity", "YearOfPurchase".

I am trying to prepare a form so as to represent this information in a matrix. I have YearOfPurchase (eg.: 2004, 2005, 2006...) as the column header and PersonName (eg.: Tom, Ron, John.....) as the row header. Such that the form would have to query the table to fill in the correct "PurchaseQuantity". Any suggestions of how to do it.

Jennie.

 

[dhookom]

Create a crosstab query with PersonName as the Row Heading, YearOfPurchase as the Column Heading, and Sum of PurchaseQuantity as the value.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[Remou]

Hi
This sounds very like a crosstab query, which can be displayed on a form, or have I missed your point?