G
Guest
I created a query using a linked table from excel and am asking it to add
three fields: Rev1 + Rev2 + Rev3. However when I run the query the expr field
is blank. I can not figure out why. The fields are numbers, not text. To
complicate matters further, I have another three fields from the same excel
table that have the same format and controls included in an expression that
does calculate correctly. Does anyone have any ideas of what I could be doing
wrong.
three fields: Rev1 + Rev2 + Rev3. However when I run the query the expr field
is blank. I can not figure out why. The fields are numbers, not text. To
complicate matters further, I have another three fields from the same excel
table that have the same format and controls included in an expression that
does calculate correctly. Does anyone have any ideas of what I could be doing
wrong.