• Complicated task (Access2000)

    Author
    Topic
    #360860

    Post deleted by princess15s

    Viewing 0 reply threads
    Author
    Replies
    • #544338

      All changes will need to be made through a form on the main fund records. then in the Afterupdate event of the form, you’d run code or update queries to update the data in the sub fund records.

      and yes, it is a poor design if the data in the sub fund records cannot be considered historical for this exact reason, which is called an update anomaly.

      Jim.

      • #544341

        Your answer is not gonna help me coz the database I’m using to extract data is different from the database you enter data. I haven’t got permission to change the design of the data entry program.

        I AGREE, it is poorly designed, but i can’t do anything about it coz it is not my program, I’m only using it to create reports.

        • #544347

          Well you’ve got 2 choices then:

          1. Run update queries in your extract database before running any reports to update the sub fund data.

          2. Base your reports on the data in the main fund records and ignore the data in the sub fund records

          Jim.

    Viewing 0 reply threads
    Reply To: Complicated task (Access2000)

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information: