Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2012
    Posts
    6

    Question Unanswered: Access expression for multiple fields

    I have a database that has two sets of data company a or company b, on company a the invoice field is called totalcurrentcharges on company b its called totalcost. Trying to run a query that will capture all invoice costs

    I did the following expression but it only returned false.

    Total: [TotalCurrentCharges] or [TotalCost]

    Is what I'm trying to do possible?

    any help will be appreciated.


  2. #2
    Join Date
    Apr 2012
    Posts
    6
    I figured it out, thought I'd share in case anyone else hit this wall

    Total: IIf([totalcost] Is Null,[Totalcurrentcharges],[totalcost])

Posting Permissions

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