How can I sort colums

[Guest]

I have a big problem:

I have a report based on a query with several colums. I want to let the user
(by filling out a form) deside, which of the colums should appear in the
report. Is this possible??? The user could possibly set a parameter or mark
the colums in the form.

The big task is to set the report printing out the marked colums beside each
other, whithout printing out the non-marked colums.

I grant a very big thank you for somebody helping me.

Good Bye

Tony

 

[John Vinson]

I have a big problem:

I have a report based on a query with several colums. I want to let the user
(by filling out a form) deside, which of the colums should appear in the
report. Is this possible??? The user could possibly set a parameter or mark
the colums in the form.

The big task is to set the report printing out the marked colums beside each
other, whithout printing out the non-marked colums.

I grant a very big thank you for somebody helping me.

This is possible, but it's not very easy: it would require opening the
Report in design mode in VBA and essentially redesigning the report
every time you open it.

What is the nature of the data? What are some of the typical
fieldnames of these columns? I don't know, but I suspect that you
might be storing data in fieldnames, and that a redesign of your
tables may be a better solution!

John W. Vinson[MVP]

 

[Guest]

The data in the fields are type "currency". This query schould generate an
offer for our products, and we have 11 deifferent material-qualities. The
user could deside, whichs material does he offer for the customer.

„John Vinson†ezt írta:

 

[John Vinson]

The data in the fields are type "currency". This query schould generate an
offer for our products, and we have 11 deifferent material-qualities. The
user could deside, whichs material does he offer for the customer.

If you have eleven different fields for eleven different materials -
your table structure is incorrectly normalized.

If you have a many-to-many relationship between offers and materials -
each offer can have one or more materials, and each material can be
part of one or more offers - then you should have THREE tables: a
table of Offers; a table of Materials (with eleven rows, not eleven
fields); and a table of OfferDetails, with an OfferID, a MaterialID,
and an amount. This will give you one *row* for each material on
offer, rather than one *field*.

John W. Vinson[MVP]

 

[Guest]

Thank you John, i will try your option.

„John Vinson†ezt írta: