Freeform Report

[icely]

Hi, I am hoping that I have not creating a thread on something that has already been covered, but if so, I apologise.

I have created a DB with around 20 tables. There is one main table that pulls data in Combo Box form from most of the other tables.

This Main table contains around 50 or so fields contained within 5 tabs in order that the user can easily enter data relevant to the situation, i.e. Tabs are Contractor Details, Agency Details, Contract Agreed Details etc.

What I want to do is create a Report where the user can select from Combo boxes and text boxes the type of report that they require.

For instance, the Contractor can select Contract Type from a Combo Box, Contractor Name from a text box, Agency Type from a Combo box and so on. The report will show around 20 selection criteria to choose from and the report will display data based on that criteria.

I am unsure how to go about this. I can create many different types of report to facilitate this but would really like to be able to have one flexible reporting system where I could enter specific criteria and not have to run a number of different reports.

I am fine to start of slow and maybe just have 3 criteria and take it from there if it is easier to start this way.

Any help would be gratefully appreciated.

Thank you.

 

[icely]

Freeform Report - 2

I am presuming that by a lack of response that the request I made is not possible or is may be too difficult to do.

I will have a play around and see if I can figure something out. If I do find an answer, i will post.

Thanks.

Si.