Crosstab Using A Set Price

[Rustin788]

Hey,



I am trying to create a crosstab that will show prices for various products. The price is set; however, throughout the year the price might change and I want to be able to show each of those numbers. So I guess I'm trying to find a way for access to treat these prices like a text value for a crosstab. Is this possible? If not, any other ideas would help greatly.

Thanks

[ranman256]

yes. Make a query that retrieves all the prices/stuff you want. save.
Use the query wizard and select crosstab qry wizard,
pick the qry made above,
pick your row items
then column items
then for prices , choose FIRST
save crosstab.

[Rustin788]

That is what I currently have. All of the sort options limit me to just one price per item per year. The query is set up like below. I want be able to see both prices in the cross tab.

Year	Customer	Stock Code	Price
2014	Nike	JL-M943	21.5
2014	Nike	JL-M943	22

Thanks for taking a look.

[June7]

Need another field that will uniquely identify each record within each year, such as month or a sequential number for all records within each year and use that field as Column Header.

An alternative is: http://allenbrowne.com/func-concat.html