how to let user choose their field from query so that it can be displayed on the repo

[Mr Key]

This should be done in reports or forms as parameter

[gits]

what report, what query, what technology at all do you use? the question is far to vague to get any answer without more information - so please rephrase the question and add some more information so that the use case is clearly understandable.

[Mr Key]

Thanks mr gits, The question is I have a query in Ms Access Database of about 30 columns (Fields), say Field1, Field2,Field3,F ield4,Field5,.. .Field30. I want a user to define which field is interested to view in a report by just enter the Field name as a parameter in a form, let say the first user want to see Field1, Field2,Field3 and Field4 the other user is interested in Field1,Field2,F ield3 and Field7 etc, Where the Field1, Field2 and Field3 will be constant for all reports while Field4...Field3 0 will be available on user request

[gits]

moved to access-forum ...

regards,
MOD