Hello...my first post, and i'm pretty new to Access - so please bear with me!
I've written a huge database for work, it contains projects, dates info are required, financial stuff and about 25 reports that generate every detail from project status to whats money has been spent, and whats left. So far so good! The forms all work well, as does the financial input / recording forms etc. The reports though have become a problem, to a point where the entire Database just isn't delivering whats required and kinda puts all my hard work under a cloud!
So, my problem(s) are:
I have a form that asks the user to select a Project Managers name (combobox) Project Engineer (combobox) and Project ID (combobox). It querys the various project tables for the 'Project Manager' 'Project Engineer' and Project ID and returns the correct text detail into the combobox.
What i would prefer is for the first combobox (Project Manager) to return its value, but then reduce the 'names' that then form the (Project Engineer) combobox selection - basically filter the results pre selection of the Project Engineer. That combobox (Project Engineer) then filters the results in the last combobox (Project ID) - in effect drill down to which project manager 'manages' which project engineer, who in turn manages which project.
Once that has been done, i then want the reports to display data based upon the combobox filters.
At the moment, i have the query written and working, the primary 'Criteria' is a date selection to give results that occur within the last say...30 days - that works fine on its own! But, if i then drop down a line to the OR statement / line on the Query and include a ref to the three noted combobox's, i dont get a filtered result, in fact i get nothing! So, i split the three refs to the combobox's over three OR statements and i can then filter via the Project Manager combobox, the Project Engineer combobox or the Project Status combobox - but not all three! The difference is about 90 pages of info when, if i could get the report to return the results filtered on the selection of the three combobox's; it would equate to circa 2 pages!
Tried loads of methods, not one works form me, and i am now very stuck!
Can anybody help me?
Even if the filtering down through the combobox's is too hard to do, the ability to have the report query only display the results that contain the stated 'project manager, project engineer, and project ID' would suffice! The date criteria is / will always to needed too.
Thanks for reading this...
I've written a huge database for work, it contains projects, dates info are required, financial stuff and about 25 reports that generate every detail from project status to whats money has been spent, and whats left. So far so good! The forms all work well, as does the financial input / recording forms etc. The reports though have become a problem, to a point where the entire Database just isn't delivering whats required and kinda puts all my hard work under a cloud!
So, my problem(s) are:
I have a form that asks the user to select a Project Managers name (combobox) Project Engineer (combobox) and Project ID (combobox). It querys the various project tables for the 'Project Manager' 'Project Engineer' and Project ID and returns the correct text detail into the combobox.
What i would prefer is for the first combobox (Project Manager) to return its value, but then reduce the 'names' that then form the (Project Engineer) combobox selection - basically filter the results pre selection of the Project Engineer. That combobox (Project Engineer) then filters the results in the last combobox (Project ID) - in effect drill down to which project manager 'manages' which project engineer, who in turn manages which project.
Once that has been done, i then want the reports to display data based upon the combobox filters.
At the moment, i have the query written and working, the primary 'Criteria' is a date selection to give results that occur within the last say...30 days - that works fine on its own! But, if i then drop down a line to the OR statement / line on the Query and include a ref to the three noted combobox's, i dont get a filtered result, in fact i get nothing! So, i split the three refs to the combobox's over three OR statements and i can then filter via the Project Manager combobox, the Project Engineer combobox or the Project Status combobox - but not all three! The difference is about 90 pages of info when, if i could get the report to return the results filtered on the selection of the three combobox's; it would equate to circa 2 pages!
Tried loads of methods, not one works form me, and i am now very stuck!
Can anybody help me?
Even if the filtering down through the combobox's is too hard to do, the ability to have the report query only display the results that contain the stated 'project manager, project engineer, and project ID' would suffice! The date criteria is / will always to needed too.
Thanks for reading this...
