
Assistance with very Access DB, re dropdown filters / query editting
- or -
Post a project like this2548
$$
- Posted:
- Proposals: 4
- Remote
- #1967663
- Awarded
Description
Experience Level: Intermediate
Hi, I'm a complete newbee with Access, trying to produce a simple database in access which outputs to an excel report, then into word. Its for my own Building Surveys, I write up the reports in access, and save regularly used clauses into a library table, which I then refer to for future, to quickly build Survey reports without having to retype. There are two main tables, tbl_survey_data (the currently report) and tbl_library, which store the repeat clauses. I have set up a cascading combo box to filter the form by report by three levels (Section, category and element) each with their own table after normalising the DB. From the combo box, I have the opportunity to 'edit the list'.
In a nutshell, I need to be able to filter popup list... this is difficult to explain....
I'd be grateful if you could help? I've reached the limit of what I can do.
Thanks
Brad
In a nutshell, I need to be able to filter popup list... this is difficult to explain....
I'd be grateful if you could help? I've reached the limit of what I can do.
Thanks
Brad

Bradley J.
100% (2)Projects Completed
1
Freelancers worked with
1
Projects awarded
25%
Last project
4 May 2018
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
Hi Brad
Thanks for contacting me. There might be a case for putting the three levels onto one table and to relate them by parent and child id. I would need to see some data to confirm this and also some data.
Many thanks
Ian C
623351
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies