|
Patch reliability is unclear. Unless you have an immediate, pressing need to install a specific patch, don't do it. |
Greetings all: I have this calculation in a query:
Addl_Hours: nz([pals_hours])+nz([cpr_hours])+nz([btls_hours])+nz([acls_hours])
I’m trying to accumulate addl_hours, however, the results show that the four fields are being concatenated instead of being added. I vaguely recall somewhere that the + sign is used as a concatenation operator, however, I want it to be an addition operator. Any and all help is appreciated. TIA.
Looks like one (or more) of your fields is being recognised as a text (or other) field rather than a numerical value. There are two things I can think of trying:
Firstly, check the properties of each field, and make sure they’re all set as number fields.
The other (and probably more robust) solution is to use the Val() function:
Addl_Hours: val(nz([pals_hours]))+val(nz([cpr_hours]))+val(nz([btls_hours]))+val(nz([acls_hours]))
If that doesn’t work, try swapping the val()s and nz()s around
Donations from Plus members keep this site going. You can identify the people who support AskWoody by the Plus badge on their avatars.
AskWoody Plus members not only get access to all of the contents of this site -- including Susan Bradley's frequently updated Patch Watch listing -- they also receive weekly AskWoody Plus Newsletters (formerly Windows Secrets Newsletter) and AskWoody Plus Alerts, emails when there are important breaking developments.
Notifications
