Post Project
  • Search
    • Buyers can
    • Search offers to buy now
    • Search freelancers to request a proposal
    • Freelancers can
    • Search projects to quote on
  • How it works
  • Log in
  • Sign up
  • Freelancer?
Browse by Category
    Technology & ProgrammingWriting & TranslationDesignDigital MarketingVideo, Photo & ImageBusinessMusic & AudioMarketing, Branding & SalesSocial Media

    Assistance with very Access DB, re dropdown filters / query editting

    - or -

    Post a project like this
    1785
    $$
    • Posted: 5 years ago
    • Proposals: 4
    • Remote
    • #1967663
    • Awarded
    David D.
    Ian C.
    Les K.Mukund S. have already sent a proposal.
    • 6
    • 6

    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
    •  
    •  
    Bradley J.
    Bradley J.
    100% (2)
    Projects Completed
    1
    Freelancers worked with
    1
    Projects awarded
    27%
    Last project
    4 May 2018
    United Kingdom

    New Proposal

    Login to your account and send a proposal now to get this project.

    Log in

    Clarification Board Ask a Question

    • 09 Apr 2018Ian C.

      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
    1785
    $$

    - or -

    Post a project like this
    Bradley J.
    Bradley J.
    100% (2)
    Projects Completed
    1
    Freelancers worked with
    1
    Projects awarded
    27%
    Last project
    4 May 2018
    United Kingdom

    Related project Searches


    editing graphics design survey design database

    Product

    • About
    • Team
    • Careers

    Support

    • How it works
    • Trust & Safety
    • Help Centre

    Discover

    • GuidesStoriesNews

    Resources

    • Customer Stories
    • Business Cost Calculator
    • Startup Cities

    Browse

    • Freelance Services
    • Freelance Services By Country
    • Freelance Skills
    • Terms
    • Privacy
    • Sitemap
    • Company Details
    • © 2023 People Per Hour Ltd
    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