Results 1 to 3 of 3
  1. #1
    Join Date
    May 2004
    Posts
    86

    Unanswered: Formatting issuse

    heres my problem, im trying to calculate this way

    but i get errors


    SELECT CFR.CFR_CHARGE, CFR.CFR_ALLOWED, CFR.CFR_DEDUCT, CFR.CFR_COINS, CFR.CFR_OTHER, CFR.CFR_COBAMT, CFR.CFR_PAID
    FROM CFR
    WHERE
    Format(Val([CFR_ALLOWED]),"=Sum""0000000000") AS [Record Total];
    much help thanks

  2. #2
    Join Date
    Dec 2002
    Location
    Préverenges, Switzerland
    Posts
    3,740
    what are you trying to do with this bit:
    WHERE
    Format(Val([CFR_ALLOWED]),"=Sum""0000000000") AS [Record Total];

    ??

    izy
    currently using SS 2008R2

  3. #3
    Join Date
    May 2004
    Posts
    86

    Im trying to sum the feilds

    Im basically trying to sum the feild but im need format in their cause my feild is 0000003000

Posting Permissions

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