Results 1 to 5 of 5
  1. #1
    amitmm_10 is offline Novice
    Windows 10 Access 2016
    Join Date
    Feb 2018
    Posts
    3

    Dynamic Data, Static fields

    Hi
    I receive daily 4 Excel files from our vendors. It has pre-defined fields, data changes every day and record vary in lines

    I want to consolidate data in access report
    How do I this in ACCESS if I have created tables with primary key and also created relationship
    Example: Similar table I receive from 4 different vendors daily
    There can be one or more common fields across different vendors.
    Vendor Broker Security Id Sec Value Value Date
    A M a 100 02/01/18
    A N b 500 02/01/18
    A M c 300 02/01/18
    A N a 100 02/01/18
    A O e 200 02/01/18



    I want to use 1st 3 relationship to show values in 4 at total levels and produce daily reports

    Can someone assist me.

    Thanks
    Amit

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    I save my excel table to the same place everytime...c:\temp\File2Import.xls
    this is already linked as an external table
    I have a query to import, its an append query from tFile2Import to my data table.

    steps:
    1. I open the excel file to use, click a macro button that saveAs to c:\temp\File2Import.xls and closes the file
    2. I click the Import button. This runs the append query.
    Done.

    Reports can now be run on 1 vendor or all ,using a form with a vendor combo box, and start and end dates boxes.

  3. #3
    amitmm_10 is offline Novice
    Windows 10 Access 2016
    Join Date
    Feb 2018
    Posts
    3
    Thank you for your prompt assistance

    If I want to run historical information, say any random date of 2017, can I do it in access/how and can I create a input form to query information for specific date.

    Thanks
    Amit

  4. #4
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,822
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  5. #5
    amitmm_10 is offline Novice
    Windows 10 Access 2016
    Join Date
    Feb 2018
    Posts
    3
    Thank you @Ranman257 and @June7 for quick response. I will work based on your suggestions.

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

Similar Threads

  1. Replies: 16
    Last Post: 05-08-2017, 04:12 PM
  2. Replies: 5
    Last Post: 07-29-2015, 02:15 PM
  3. Replies: 8
    Last Post: 07-30-2012, 04:43 PM
  4. Replies: 1
    Last Post: 08-31-2010, 03:49 PM
  5. Dynamic fields reference
    By tuna in forum Forms
    Replies: 0
    Last Post: 05-04-2010, 11:47 PM

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