Help with Query to show in row

[DaveT99]

Hello


I am trying to create a cost tracking table & query
have created a table with Item_Id, Date, Latest Price

so eventually I will have a table of dates and latest price for item1, 2, 3, etc

How is the best way to show data in a single row the price trend for a Item 1 (row 1), Item 2 row 2, etc, can this be done in a query?

so Rew 1 would show Item 1, then cost (date1), cost (date2), cost (date 3) etc

I tried a cross tab query but that didnt work

Hope this is clear

[ranman256]

use a SINGLE RECORD form, bound to your query.
user can see only 1 record at a time.

but if you want to view them (not recommended) as ITEM1, cost1,date1, cost2,date2
then use a CROSSTAB query.

to use crosstab or TREND report/chart, you want data in a query as:
ITEM1, DATE1, COST1
ITEM1, DATE2, COST2
ITEM2,DATE1, COST1
etc

the charts/trends read this type of query.

[DaveT99]

[QUOTE=ranman256;424758]use a SINGLE RECORD form, bound to your query.
user can see only 1 record at a time.

but if you want to view them (not recommended) as ITEM1, cost1,date1, cost2,date2
then use a CROSSTAB query.

to use crosstab or TREND report/chart, you want data in a query as:
ITEM1, DATE1, COST1
ITEM1, DATE2, COST2
ITEM2,DATE1, COST1
etc

the charts/trends read this type of query.[/QUOTE

[DaveT99]

Thanks will try the cross tab again and if I fail will try the single record form

Many thanks for your prompt reply
Cheers

[DaveT99]

Thanks Mr Ranman............Managed 2nd time round using the CROSSTAB query. I had never used this function before