K
KA
I am trying to create dynamic reports. I have a report
that has 20 fields in it. The information is filtered
from a form. I need the report to display only the fields
that i run a filter on. If i select 5 fields in the form
then i only want to see those 5 fields in the report. I
need the report to generate itself as if it were a query.
How do you do this in Access? I currently am forced to
insert all 20 fields, readjust the width of the null
fields and then write senarios to move the valid fields
over top of the null fields. With 1 to 5 fields its not
to bad. With 20 fields and all of the different
combinations one could select. This is getting crazy! If
anyone has a way of doing this please respond.
that has 20 fields in it. The information is filtered
from a form. I need the report to display only the fields
that i run a filter on. If i select 5 fields in the form
then i only want to see those 5 fields in the report. I
need the report to generate itself as if it were a query.
How do you do this in Access? I currently am forced to
insert all 20 fields, readjust the width of the null
fields and then write senarios to move the valid fields
over top of the null fields. With 1 to 5 fields its not
to bad. With 20 fields and all of the different
combinations one could select. This is getting crazy! If
anyone has a way of doing this please respond.