Search results

  1. J

    Query Eliminating too much

    Here is my query as it stands. SELECT t.AR_OPN_CUS_NO, t.AR_OPN_DOC_DT, t.AR_OPN_DOC_DUE_DT, t.AR_OPN_DOC_TP, t.AR_OPN_DOC_DT, t.AR_OPN_DOC_NO, t.AR_OPN_APPLY_TO, t.AR_OPN_REF, t.AR_OPN_AMT1, t.AR_OPN_AMT2, Sum(t.Sub) AS SumOfSub FROM AROpen AS t INNER JOIN FindBalances AS q ON...
  2. J

    Text Format as Phone

    I have a silly little problem I need help with. I have a text field in my report that is actually 10 digits (the field is formatted as text - cannot be changed as it is linked to a database in another program) 1234567890 I need it to look like a phone number 123-456-7890 I use this as my...
  3. J

    Show Open Balance Customers Only

    HI all! I need a little help with a query that isn't returning EXACTLY the info I want. here is what I am currently getting... Cust NO. , Name , DocType , DocDate , DocNum , DocApply , Subtotal 001436 , NBK , Invoice , 2/3/2004 , 212034 , 212034 , 90.00 001436 , NBK ...
Back
Top Bottom