Results 1 to 3 of 3

Thread: Writing sql for a table to extract information for reporting
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Jul 2019
    Posts
    38
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Writing sql for a table to extract information for reporting

    HELLO EXPERTS,

    I NEED TO WRITE A SIMPLE SQL TO EXTRACT DATA FROM A TABLE. TABLE IS ALREADY EXTRACTING DATA FROM MULTIPLE FILES AND IS REFRESHING WELL WHEN DATA IS UPDATED IN SOURCE FILES.

    NOW FROM THIS TABLE I NEED TO WRITE COUPLE OF COMMANDS / SQL IN DIFFERENT SHEETS / WORKBOOKS WHICH MAY USE SOME KIND OF "REFRESH" OPTION WHEN NEEDED.

    Source.Name INVOICE NO. BL DATE P.I. NO. OFFICE BUYER CARTONS QUANTITY GROSS VALUE DEPOSITS NET VALUE TENOR DUE DATE LC NO. DESCRIPTION SUPPLIER SUPPLIER INV. NO. IMPORT AMOUNT VESSEL NAME LOADING DESTINATION


    THIS IS THE HEADER AND FOR AN EXAMPLE I NEED TO TO MAKE A REPORT WHICH MAY BRING:

    INVOICE NO.
    BL DATE
    P.I. NO.
    BUYER
    GROSS VALUE
    DEPOSITS
    NET VALUE

    THAT MATCHES THE "BUYER" = "XYZ COMPANY" AND AUTOMATICALLY ADDING A TOTAL FOR:

    GROSS VALUE
    DEPOSITS
    NET VALUE

    NOW FROM ORIGINAL TABLE IF IT GET "REFRESHED" THE REPORT MAY ALSO HAVE AN OPTION TO "REFRESH" APPENDING NEW ENTRIES (IF ANY).

    PLEASE GUIDE / ADVISE.

    THANKS IN ADVANCE.

  2. #2
    New Member
    Join Date
    Jul 2019
    Posts
    38
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Writing sql for a table to extract information for reporting

    Quote Originally Posted by shah0101 View Post
    hello experts,

    i need to write a simple sql to extract data from a table. Table is already extracting data from multiple files and is refreshing well when data is updated in source files.

    Now from this table i need to write couple of commands / sql in different sheets / workbooks which may use some kind of "refresh" option when needed.

    source.name invoice no. bl date p.i. No. office buyer cartons quantity gross value deposits net value tenor due date lc no. description supplier supplier inv. No. import amount vessel name loading destination


    this is the header and for an example i need to to make a report which may bring:

    Invoice no.
    Bl date
    p.i. No.
    Buyer
    gross value
    deposits
    net value

    that matches the "buyer" = "xyz company" and automatically adding a total for:

    Gross value
    deposits
    net value

    now from original table if it get "refreshed" the report may also have an option to "refresh" appending new entries (if any).

    Please guide / advise.

    Thanks in advance.








    can a vba code help me on that?


    Any one?

  3. #3
    New Member
    Join Date
    Jul 2019
    Posts
    38
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Writing sql for a table to extract information for reporting

    Quote Originally Posted by shah0101 View Post
    can a vba code help me on that?


    Any one?




    is it to much to ask here?

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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