Results 1 to 9 of 9
  1. #1
    4 Star Lounger
    Join Date
    Aug 2001
    Location
    London, UK
    Posts
    516
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Urgent help needed. (Access2000)

    I have a database with two input screens. The 1st screen is used to input the total expense in the month, which is then saved as a record and the 2nd screen is used to allocating the total amount into sub expenses such as bills, food, rent, etc, each of these expenses are saved in a table with different ID numbers.
    In the 1st screen the user enters some data such as User name and this data applies to the main expense as well as the sub expenses. The problem I

  2. #2
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: Urgent help needed. (Access2000)

    What is the relationship between your 2 tables, and what are the common fields? It seems to me that the common field should be an ID number of the transaction in the primary table, not a name field.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

  3. #3
    4 Star Lounger
    Join Date
    Aug 2001
    Location
    London, UK
    Posts
    516
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Urgent help needed. (Access2000)

    The problem is that both forms are based on 1 table (I know it's silly but I did not design these tables)

  4. #4
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Urgent help needed. (Access2000)

    Maybe it's time you started talking sternly to the person who did design the tables. If they're no longer there and you're now responsible for them, then start changing the designs.
    Charlotte

  5. #5
    4 Star Lounger
    Join Date
    Aug 2001
    Location
    London, UK
    Posts
    516
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Urgent help needed. (Access2000)

    It is a program desined by a professonal(of somekind) and bought by the company I work for. I'm only using the data in the table to create some reports. I can not touch the design of the tables coz it's locked. I'm ONLY a student who does work experience with this company.

  6. #6
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Urgent help needed. (Access2000)

    Ouch! I've run into that kind of "professional" before. They charge the earth and give back dirt for the money. <img src=/S/sick.gif border=0 alt=sick width=15 height=15> In that case, you may need to create your own design and pull data into it in order to get what you need. Otherwise, suggest to the company that they track down the "professional" and hold his feet to the fire until he fixes it.
    Charlotte

  7. #7
    4 Star Lounger
    Join Date
    Aug 2001
    Location
    London, UK
    Posts
    516
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Urgent help needed. (Access2000)

    He is gonna come and tailer make the program to suit the company, in the mean time I have been asked to do this. Is that the only way I could do this?

  8. #8
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Urgent help needed. (Access2000)

    It's the only way to do it in a reasonable length of time. If you can't properly relate the tables, then you can't get the data you want into a report. Unfortunately, it's possible that he secured the back end so you may *not* be able to import the tables. As a workaround, you might try querying them with Excel to get the data and then doing a cut and paste in Excel to produce the report.
    Charlotte

  9. #9
    4 Star Lounger
    Join Date
    Aug 2001
    Location
    London, UK
    Posts
    516
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Urgent help needed. (Access2000)

    Thanks charlotte.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •