Results 1 to 4 of 4
  1. #1
    mrt1069 is offline Novice
    Windows 10 Access 2016
    Join Date
    May 2016
    Location
    Alabama
    Posts
    9

    Pull corresponding data into report

    Hello, hello.

    I am trying to work up a query report for some purchasing data analysis, but the problem is that my crappy old version of access can't handle enough inputs.



    Here's the current setup.

    The table purchase.tbl is filled in via a form purchase.frm. purchase.frm has 10 items with 1) Item number 2) item material 3) item description 4) item cost 5) supplier number 6) Purchase Number (50 total fields for each of the 10 items w/ supplier number and purchase number being a single value)

    I would like to be able to query a supplier number and pull up all of this information, but my version of access simply cannot handle it (upgrading isn't an option)

    Does anyone know a good workaround for my problem here?

    I was thinking of doing a query for just the 10 item numbers, 1 supplier number, and 1 purchase number and then use text boxes on the report to pull in the rest of the corresponding data, but I don't even know how to do that anymore.

    Let me know if you know a good solution or if my idea might work and how I might go about implementing it.

    Thank you!

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    It sounds like you have a design problem, not a problem with Access. You have fields for Item1, Item2, Cost1, Cost2, etc? If so, there's your problem. I'd correct the design, but if it's too late and you're saying you don't have enough "Or" rows in the design grid, you can switch to SQL view and add others manually.

    But I'd fix the design:

    Fundamentals of Relational Database Design -- r937.com
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    mrt1069 is offline Novice
    Windows 10 Access 2016
    Join Date
    May 2016
    Location
    Alabama
    Posts
    9
    Yeah, it's definitely too late to change the design. Thank's for the SQL tip.

  4. #4
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    No problem. Another thing you can do is "normalize" the data with a UNION query, then query against that. Might be an advantage because you'll probably have to work around this design in other ways.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Form to pull report
    By Michael.Reynolds1775 in forum Forms
    Replies: 5
    Last Post: 03-25-2015, 01:04 PM
  2. Pull Data from another table
    By bbranco in forum Access
    Replies: 1
    Last Post: 06-19-2013, 06:15 AM
  3. Replies: 2
    Last Post: 03-07-2013, 04:50 PM
  4. Replies: 1
    Last Post: 01-14-2013, 11:28 AM
  5. How can pull this data?
    By cap.zadi in forum Queries
    Replies: 21
    Last Post: 01-23-2012, 03:09 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums