Results 1 to 3 of 3
  1. #1
    Lounger
    Join Date
    Aug 2008
    Location
    Daytona Beach, Florida, USA
    Posts
    42
    Thanks
    3
    Thanked 0 Times in 0 Posts
    I have a query that I creating to use to create a billing summary for employees that worked at a billable location. I have a caluculated column for the Salary and the Taxes. I need to add the two columns, but when I try to do this using "total: [Salary]+[Taxes]" I get the information in both columns combined as one instead of being added together, such as"$146.88$29.38"

    Does anyone know what I am doing wrong?

  2. #2
    5 Star Lounger AndrewKKWalker's Avatar
    Join Date
    Apr 2001
    Location
    Cambridge, UK
    Posts
    1,020
    Thanks
    0
    Thanked 3 Times in 3 Posts
    What data type are Salary and Taxes.
    It looks like they are being concatenated.
    Normally you would use & to concatenate 2 text fields together, but + does the same job with text data.
    Andrew

  3. #3
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts
    Quote Originally Posted by brandy9271 View Post
    I have a calculated column for the Salary and the Taxes.
    Are you saying that Salary and Taxes are themselves calculated amounts? If so what expressions are you using for the calculations? Some expressions convert the results to text . e.g the Format function.
    Regards
    John



Posting Permissions

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