An expression from a linked excel table will not calculate

  • Thread starter Thread starter Guest
  • Start date Start date
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.
 
Please post the SQL statements for both the working and non-working queries.

Jeff Boyce
<Access MVP>
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top