Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2007
    Posts
    2

    Red face Unanswered: Access 2003 Expressions

    I have created an Access database that stores Software Licenses for my company. As I view each software license and its quantity in “Form View”, I would like to see the current total number of licenses for that particular license. Using Project 2000 as an example, if I'm viewing a Microsoft eOpen license for Project 2000 with a quantity of 10, I would like to be able to view the total number of licenses stored in the database for Project 2000, without including other licenses such as Microsoft Office, Visio, etc...
    The Software License Name is stored in a field called “Software”. The quantity for each license is stored in a field called “Quantity”. The name of the table is "Software License Table". The calculated results will be viewed in the form as the “Total Count”.
    I have been trying to use the DSum() function in the expression below with no luck. I need to be able to transer the contents of the [Software] field to the "criteria" portion of the function as noted below with the "?":

    =DSum("[Quantity]", "Software License Table", "[Software]= ?")

    What is the proper syntax for the expression that I need?
    Is there additional code that needs to be entered?
    Is this the right function?
    Am I totaly off the mark?

    Your help will be greatly appreciated. Thanks.

  2. #2
    Join Date
    May 2005
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6
    Good reference here:

    http://www.mvps.org/access/general/gen0018.htm

    By the way, you will probably need to bracket the table name, given the inadvisable spaces.
    Paul

Posting Permissions

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