Solved

Calculated field in a table

Posted on 2013-11-23
2
247 Views
Last Modified: 2013-11-23
I'm trying to include a calculated field in table design.  The fields I'm using for the calculation are:

[LeadFromEd]+[AgentLead]+[CommissionSoldListing]

But I'm also trying to account for empty values by using:

Nz([LeadFromEd],0)+Nz([AgentLead],0)+Nz([CommissionSoldListing],0)

But it won't let me.  I get an error that reads,

The expression Nz([LeadFromEd],0)+Nz([AgentLead],0)+Nz([CommissionSoldListing],0) cannot be used in a calculated column.

????

--Steve
0
Comment
Question by:SteveL13
2 Comments
 
LVL 120

Accepted Solution

by:
Rey Obrero (Capricorn1) earned 500 total points
ID: 39671485
this is not a good  idea.

you can always derived a calculated column using a query.
0
 
LVL 18

Expert Comment

by:Jerry Miller
ID: 39671509
I agree with capricorn1 that it is not a good idea. If you need the values, use a query to determine your derived columns. It violates normalization rules.
0

Featured Post

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

773 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question