Results 1 to 8 of 8

creating an if formula with sum

  1. #1
    OMARNAHAS is offline Novice
    Windows 10 Access 2016
    Join Date
    Feb 2016
    Posts
    4

    creating an if formula with sum


    I am trying to sum a list of values with a specific criteria

  2. #2
    cyanidem's Avatar
    cyanidem is offline Competent Performer
    Windows 10 Access 2010 64bit
    Join Date
    Nov 2015
    Location
    Consett, UK
    Posts
    270
    SomeVariableOrSomethingElse = Iif(something, value1+value2+value3, something else)

    Will that work for you?

    (Hint: we need more data)

  3. #3
    OMARNAHAS is offline Novice
    Windows 10 Access 2016
    Join Date
    Feb 2016
    Posts
    4
    i am new on access. trying to get to know it better alone by creating DBs (tbl/qry/frm & rpt)
    i am facing some problems specially i am coming from an excel background

    many things cant be done in access same as excel.
    how can i show u the DBs i am working with, bcoz have many ?

  4. #4
    OMARNAHAS is offline Novice
    Windows 10 Access 2016
    Join Date
    Feb 2016
    Posts
    4
    i have a list composed by shipment nbr and loading qty
    i want to total qty of the shipment numbers

  5. #5
    cyanidem's Avatar
    cyanidem is offline Competent Performer
    Windows 10 Access 2010 64bit
    Join Date
    Nov 2015
    Location
    Consett, UK
    Posts
    270
    Some sample data, screenshots, what would you expect to achieve, etc. would be helpful. You can also upload your database - remove confidential data, use database tools -> compact and repair and zip your db if it's still too big.

  6. #6
    OMARNAHAS is offline Novice
    Windows 10 Access 2016
    Join Date
    Feb 2016
    Posts
    4
    db IS SMALL
    HOW TO ATTACH IT TO THIS THREAD
    OR GIVE ME YOUR EMAIL PLS

  7. #7
    cyanidem's Avatar
    cyanidem is offline Competent Performer
    Windows 10 Access 2010 64bit
    Join Date
    Nov 2015
    Location
    Consett, UK
    Posts
    270
    Copy/paste from June7 signature:


    To provide db: Make copy, remove confidential data, run compact & repair, zip w/Windows Compression if over 500KB (2MB zip allowed), attach to post. Attachment Manager is below the Advanced post editor window, click Go Advanced below the Quick Reply window.

  8. #8
    orange's Avatar
    orange is offline Moderator
    Windows 8 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    14,327
    omarnahas,

    You will probably reduce your learning curve by working through a tutorial or 2 from RogersAccessLibrary. Learning Access by trial and error is a poor strategy. Each tutorial can be completed in 45-60 minutes and will teach you concepts that can be used with any database.
    These tutorials come with problem description, a process to follow and a solution. You have to work through them to get the benefit.

    Knowing Excel may increase your database/Access learning time because you have to leave much of your spreadsheet familiarity behind.

    Here are some tutorials that will help you with database.

    Class info
    ERDiagramming

    If you have access to youtube, then watch these for more on concepts.

    Database Intro
    Relational model
    Data modelling

    Good luck.

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

Similar Threads

  1. Replies: 19
    Last Post: 07-13-2015, 10:15 AM
  2. Replies: 3
    Last Post: 03-24-2015, 04:42 AM
  3. Confused while creating formula
    By snipe in forum Programming
    Replies: 3
    Last Post: 12-09-2014, 04:50 PM
  4. Need help creating a formula
    By Jimmy0291 in forum Queries
    Replies: 1
    Last Post: 01-17-2011, 12:12 PM
  5. Creating Formula In The Form
    By mastee in forum Access
    Replies: 3
    Last Post: 04-19-2010, 05:52 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