Calculated Fields in Access Query

[mrmarc]

This works for me in Calculated Field Expression:
IIf([Grade]="N2",[NumberOfCases]*28,0)

But this does not:

IIf([Grade]="N2",[NumberOfCases]*28+[LoosePounds],0)

Both Fields "NumberOfCases" and "LoosePounds" are integers which can be Null.

Any Ideas?

 

[Joe4]

Also guys I made a mistake, maybe this will help. This is a calculated field IN a TABLE not a query. Sorry about that.

Here is some advice. Do not use Calculated Fields in a Table! I know it is a new feature, but that doesn't necessarily mean it is a good idea.
Most other larger database programs like SQL and Oracle do not allow this, so if you ever needed to convert/upgrade your database, this will cause issues!

Also, I can see very little reason for the need for this. This can all be done in a query (and probably should be done in a query). Seeing as how pretty much anything you can use a Table for in Access, you can also use a Query for, I cannot think of any advantage to doing the calculation in the table instead of a query.

I have never done a calculation at the table level, but based on what you are seeing, Calculated Expressions at the Table level may have more limitations that doing it at the Query level.

 

[mrmarc]

Here is some advice. Do not use Calculated Fields in a Table! I know it is a new feature, but that doesn't necessarily mean it is a good idea.
Most other larger database programs like SQL and Oracle do not allow this, so if you ever needed to convert/upgrade your database, this will cause issues!

Also, I can see very little reason for the need for this. This can all be done in a query (and probably should be done in a query). Seeing as how pretty much anything you can use a Table for in Access, you can also use a Query for, I cannot think of any advantage to doing the calculation in the table instead of a query.

I have never done a calculation at the table level, but based on what you are seeing, Calculated Expressions at the Table level may have more limitations that doing it at the Query level.

Thanks for the advice Joe! I'm going to switch everything over to a query then.