Access Query Formula

[nancybrown]

My source document is an excel spreadsheet uploaded in Access (tblRicoh). This Excel spreadsheet is used to send to our printer to have checks printed. There is a field called Amount (represents $ of check) and a column called Amount Spelled Out. This is exactly what it says . . . it spells the dollar amount in the Amount column spelled out (like any printed check), the code for example is =spellnumber(F2) and returns a value of #Name ? This is required by the printer's merge template.

In Access, is there a way to insert an extra column in a query and duplicate this formula so when the query results is exported has incremental rows for =spellnumber( ) and the #Name ?

 

[Leandroarb]

Hi Nancy,
Yes there is!
Within your access query, in an empty field you can enter a virtual field. For this you can name with any name doing so:
Name: Formula

 

[Micron]

Just to clarify for nancybrown, what precedes the : is the name of the aliased field. Maybe neither of you would use the word "Name" for this or any other Access object, but just in case, I'll point out that it's a reserved word and should not be used anywhere other than when referring to the Name property of an object. For a great list, see
http://allenbrowne.com/AppIssueBadWord.html#N

Any expression that returns #Name as a result is an error that probably isn't going to help.

 

[Leandroarb]

Just to clarify for nancybrown, what precedes the : is the name of the aliased field. Maybe neither of you would use the word "Name" for this or any other Access object, but just in case, I'll point out that it's a reserved word and should not be used anywhere other than when referring to the Name property of an object. For a great list, see
http://allenbrowne.com/AppIssueBadWord.html#N

Any expression that returns #Name as a result is an error that probably isn't going to help.

You're correct Micron!
But what I wanted to exemplify with the word "Name" is the name of the field.

 

[Micron]

I suspected as much but wasn't sure. What I do in these cases is something like MyFieldName:Expression or AliasName:Expression. Anything but a reserved word if at all possible. That way I won't contribute to other problems if my suggestion is taken literally. It's just the way I try to post.

 

[Leandroarb]

I suspected as much but wasn't sure. What I do in these cases is something like MyFieldName:Expression or AliasName:Expression. Anything but a reserved word if at all possible. That way I won't contribute to other problems if my suggestion is taken literally. It's just the way I try to post.

You are correct one more time!
Apologize me.