• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 254
  • Last Modified:

Calculated field in a table

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
SteveL13
Asked:
SteveL13
1 Solution
 
Rey Obrero (Capricorn1)Commented:
this is not a good  idea.

you can always derived a calculated column using a query.
0
 
Jerry MillerCommented:
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

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now