Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2006
    Posts
    9

    Unanswered: Access 2007 DSum issues

    Trying to put together a query and include dsum to roll up sales numbers. The group that I need to roll by is ISBN (text field). Trying to learn via the Northwind db to get results via month, year, employee id (MS examples), but when I try by a text value (like country or city) I get the #Error. Example I'm using in the NW db is

    RunTot: DSum("Freight","Orders","[shipcountry]<=" & [countryalias] & "")

    Where countryalias is the ship country.

    Thanks!

  2. #2
    Join Date
    May 2010
    Posts
    601
    I find the DSUM() in a query is very slooooooow. I never use them in a query.

    You might also be able to use a totaling query. You can also use a sub query


    See: Subquery basics
    Boyd Trimmell aka HiTechCoach HiTechCoach.com (free access stuff)
    Microsoft MVP - Access Expert
    BPM/Accounting Systems/Inventory Control/CRM
    Programming: Nine different ways to do it right, a thousand ways to do it wrong.
    Binary--it's as easy as 1-10-11

Tags for this Thread

Posting Permissions

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