I am trying to sum a list of values with a specific criteria
I am trying to sum a list of values with a specific criteria
SomeVariableOrSomethingElse = Iif(something, value1+value2+value3, something else)
Will that work for you?
(Hint: we need more data)
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 ?
i have a list composed by shipment nbr and loading qty
i want to total qty of the shipment numbers
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.
db IS SMALL
HOW TO ATTACH IT TO THIS THREAD
OR GIVE ME YOUR EMAIL PLS
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.
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.