How do I get the total value of three fields? - Microsoft Community

hi

i'm trying use expression

[amount due 2017]+[amount due 2016]+[amount due 2015]

to calculate total 3 fields mentioned in expression!

the expression works when there values in of fields used in expression , need expression work when @ least 1 of fields contains value!

any advise or assistance in regard highly appreciated!

you should study how relational databases work. can find resources here - you'll need register it's free , utteraccess community welcoming , helpful.

one basic principle each kind of entity - real-life thing, person, or event - should have own table. client 1 kind of entity; document kind; payment yet another. need table of clients containing client firstname, lastname, other biographical data - nothing client's payments; table clients' payments, containing clientid (a link clients table paid), payment date, amount, etc., nothing client's name, address, etc. 

access lets store data in tables; connect information different tables in queries; build forms let create, update, , manage data in queries; , build reports pull multiple tables' data display or printing. tables should kept "under hood"; tools combos , other controls on forms provide user-friendly interface, while tools in table datasheets more limited.

there's largish learning curve making use of access - it's not "out of box" finished application, rather well-stocked tool kit build applications. there bit of study , work learning complexities, we're here help!

Office / Access / Other/unknown / Office 2016