Generic reports

[Peter]

I wish to give users the functionality to allow them to
produce their own reports - field selection, set criteria
etc.

Could someone please advise me with the best solution.
Many thanks.

 

[Peter]

Larry,

Many thanks for the reply.

Your response what pretty much what I was expecting.
As a result, I will now pursue these avenues.

Thanks again.
Peter.

-----Original Message-----
If they are to have more than very minimal report- writing capability, my
experience is that you may be best served by giving them some brief lessons
on creating Access' reports.

If it is merely selecting columns from a predefined list then that will be
relatively easy to code. I've seen that done, but, to be honest, the users
of the application did not find it useful and did not use it -- they
preferred the more complete, more structured reports that were not just
"listings of particular data fields".

Specifying criteria is a separate issue from

constructing Reports. You allow

 

[Junir]

Peter:

This can be done...with VBA.
Only thing user has to do is choose the table and field
with and or statment. It will require some man hours to
write but its do able. Please contact me at the above
address for more info.

Junir