Results 1 to 3 of 3

Function required for access similar to sumif function of excel

  1. #1
    mevaraj is offline Novice
    Windows 10 Access 2010 32bit
    Join Date
    Feb 2017
    Posts
    1

    Function required for access similar to sumif function of excel

    Respected Sir,
    I am looking for a substitute for sumif function for access as there is no sumif function in access. after doing some google I found DSUM for access....but I am not getting my result.... Kindly help me out. the detail of the question is as under:-

    I have a table for employee data base link with excel where there monthly salary detail are entered I have included one field in that data base .. projected Gross Salary ....My question is that I want to sum the projected Gross Salary if its meet the condition Employee No. .....where

    EMPLOYEE NO ......... IS THE CODE OF THE EMPLOYEE
    DATA ............... IS THE NAME OF TABLE
    PROJECTED GROSS SALARY ............. IS THE FIELD TO BE SUM

    ALL THIS FIELD ARE NUMBERIC NO TEXT FIELD.

    I HAVE USED THE D SUM FUNCTION BUT I AM GETTING AN ERROR / ONLY IF I CHANGE THE FIELD TO TEXT FORMET. THE RESULT ARE COMING BUT WITH AN ERROR "ENTER PARAMETER" ..............THE FORMULA I HAVE ENTER IS AS UNDER:-

    =DSum("[PROJECTED GROSS SALARY]","DATA","[EMPLOYEE NO]=""" & [ EMPLOYEE NO] & """") '(Kindly do it for text and numbric data type



    I WILL BE GLAD IF YOU COULD HELP ME WITH THIS ...... AND IF YOU COULD ADD A DATE FIELD ALSO .I.E DSUM PROJECTED GROSS SALARY FROM TABLE DATA CONDITION EMPLOYEE NO UP TO MONTH . SO THAT IT DOES NOT TOTAL THE WHOLE SALARY OF A PARTICULAR EMPLOYEE IN STARTING MONTH.

    I am doing this on a report using a textbox where i want the total to appear.

    ____________________
    thanking you in advance.....Raj

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    20,719
    See if this helps. There's a multi-criteria example at the bottom:

    DLookup Usage Samples
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    20,719
    Oh, and the parameter prompt is Access telling you it can't find something (whatever the prompt says). Double check the spelling of whatever it is asking for.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 9
    Last Post: 09-07-2018, 04:59 PM
  2. Replies: 4
    Last Post: 03-04-2016, 10:08 AM
  3. SumIF Function?
    By LeoGets in forum Access
    Replies: 13
    Last Post: 01-22-2014, 06:39 PM
  4. Help required for DLookup function
    By cheyanne in forum Forms
    Replies: 11
    Last Post: 04-13-2012, 12:44 AM
  5. excel function in access
    By lmp101010 in forum Queries
    Replies: 1
    Last Post: 08-03-2010, 05:02 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Tech Forums: Microsoft Office Forums