Creating a form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 ?
 
You should probably tell us what in your specifications prohibits the use of
a pivot table or crosstab?
 
Duane said:
You should probably tell us what in your specifications prohibits the use of
a pivot table or crosstab?
Click to expand...
Could the Code Modules:EditCrosstab from my site help you?
 
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) ?
 
Back
Top