Hello,
I don't have a lot of experience with Access and I'm having trouble determining the results received from a field expression that is using the NZ function. The expression is M-BEGIN INVENT: Nz([current.begin invent],0) where "current.begin invent" is datatype "number" in the source table. The issue is that this expression is leaving the format of the field as a "string" so when exported to Excel it must be converted back in order to run mathematical calculations on the results.
Trying to read up on this but not getting anywhere.
Any assistance would be greatly appreciated!
Thanks