Results 1 to 3 of 3
  1. #1
    Leonine is offline Novice
    Windows 11 Office 365
    Join Date
    Sep 2023

    Inventory report for multiple locations

    This is probably pretty straight-forward coding, but I've not been able to figure it out! I have a query that creates a list of active inventory items with names and locations. Each item name may have one to several locations. I would like to print a list by item name that show what location(s) it is at. Example: item1: loc1, loc3, loc5 item2: loc8 item3: loc2, loc3 Any assistance would be greatly appreciated!

  2. #2
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Ontario, Canada
    Assuming your tables are correctly designed, look into using a crosstab query and group by item and location. If you designed your tables like spreadsheets then I think you'll have a harder time doing this. By spreadsheet design, I mean you'd have something like
    Item1 Location Item2 Location Item3 Location
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

  3. #3
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Nevada, USA
    Depending on your structure, this may be an option as well.
    Paul (wino moderator)
    MS Access MVP 2007-2019

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

Similar Threads

  1. Replies: 2
    Last Post: 06-02-2022, 03:48 PM
  2. Inventory Across Multiple Locations or Warehouses
    By USMCPelto in forum Database Design
    Replies: 4
    Last Post: 02-25-2020, 04:59 PM
  3. Inventory Management - Warehouse locations
    By jharper in forum Database Design
    Replies: 1
    Last Post: 05-28-2014, 06:20 AM
  4. Tracking Inventory At Multiple Locations
    By Dustin in forum Database Design
    Replies: 4
    Last Post: 12-28-2013, 10:32 PM
  5. Replies: 1
    Last Post: 06-17-2012, 12:38 AM

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