Results 1 to 7 of 7
  1. #1
    Join Date
    May 2009
    Location
    Crete, Greece
    Posts
    90

    Unanswered: Multiple additions in query

    Is there a better way to add together multiple fields on a query - I've got

    Expenses Total: [ExpensesKalfakis]+[ExpensesGuides]+[ExpensesOfficialGuides]+[ExpensesVAT]

    but I know that excel doesn't like formulas like this and I think it might come back and bite me at some point.

    Thank you!

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    how would you expect it to be better than that
    do you expect their to be some magic process in background that happens to suss that these columns are called the same and should be added together

    also I odn;'t get the relevance of the reference to Excel..
    is this an excle problem or an access problem
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    May 2009
    Location
    Crete, Greece
    Posts
    90
    Very well. Why do you frequently answer these posts when you seem to dislike people asking questions?

  4. #4
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    no, you have a working solution.

    what Im trying to ask is what other way do you think there should be out there.

    as I said before there is no magical solution, there is a limit to how clever any database engine can be.

    my responses make no assumptions, likes or dislikes of people.
    I'd rather be riding on the Tiger 800 or the Norton

  5. #5
    Join Date
    May 2009
    Location
    Crete, Greece
    Posts
    90
    Just for interest, if we used this expression in excel it may return an incorrect value, because you need to group the equation with brackets, much like the way we used to do in maths lessons at school. Although sometimes it may not. I wondered whether Access preferred some better syntax.

  6. #6
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    you may needs to cater for null values in your expression, but apart fromt hat it should be OK
    I'd rather be riding on the Tiger 800 or the Norton

  7. #7
    Join Date
    May 2009
    Location
    Crete, Greece
    Posts
    90
    Will use NZ. Thanks for that.

Posting Permissions

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