Creating a form

[Luis]

Hi.
I have a table with information stored as i put bellow:

Field1 Field2 Field3
Item1 Warehouse1 AmoutItem1Warehouse1
Item1 Warehouse2 AmoutItem1Warehouse2
Item1 Warehouse3 AmoutItem1Warehouse3
Item2 Warehouse1 AmoutItem2Warehouse1
..
..

I want to create a form that displays the information like i show bellow:

Warehouse1 Warehouse2
Item1 AmoutItem1Warehouse1 AmoutItem1Warehouse2
Item2 AmoutItem2Warehouse1 AmoutItem2Warehouse2

I only found out a way to do this that was creating a pivot table. But this
an approach i don't want. Can i programatically create this form ?

 

[Duane Hookom]

You should probably tell us what in your specifications prohibits the use of
a pivot table or crosstab?

 

[Bas Cost Budde]

You should probably tell us what in your specifications prohibits the use of
a pivot table or crosstab?

Could the Code Modules:EditCrosstab from my site help you?

 

[Luis]

If i use a pivot table the users can expand to details that i don't want, and
there are totals that its not necessary.
If i use a crosstab query, In which type of form can i use it in order to be
able to format the form i want (Heading, Footer, background, etc) ?

 

[Luis]

Forgot to mention that the number of warehouses can vary.

 

[Duane Hookom]

Assuming you don't need to be able to edit the records then consider a
crosstab report. There are some samples at
http://www.invisibleinc.com/divFiles.cfm?divDivID=4