Search:

Type: Posts; User: hgriff16; Keyword(s):

Search: Search took 0.01 seconds.

  1. Re: Cross Tab Query How to Get Distinct Values

    This worked perfectly, Thank you so much.
  2. Re: Cross Tab Query How to Get Distinct Values

    <colgroup><col span="2"><col><col></colgroup><tbody>
    Service Location Name
    Fulfillment Order ID
    Date Fulfilled (Common)
    Total Parts Cost


    Albany
    1
    10/1/2019
  3. Re: Cross Tab Query How to Get Distinct Values

    Here is the SQL data.

    TRANSFORM Sum([bo5a]![Total Parts Cost]+3.5) AS Expr1
    SELECT bo5a.[Service Location Name]
    FROM bo5a LEFT JOIN Calander ON bo5a.[Date Fullfilled (Common)] = Calander.[2019]...
  4. Cross Tab Query How to Get Distinct Values

    Hello everyone, This is my first time posting just as an FYI. I am trying to make a cross tab query that shows Location as the rows and Week Number as the Columns with a value set up in builder. ...
Results 1 to 4 of 4