Expression Question

  • Thread starter Thread starter rciolkosz
  • Start date Start date
R

rciolkosz

I have a query running off of two queries. In one of the queries I have a
val expression dropping off the alpha portion of a number. Problem seems to
be that it is still recognized as a text and I now get a type mismatch in
expression.
 
That's strange as Val returns a number and not a string. Use one of the type
conversion functions such as CDbl to change it into a number. Something like:

CDbl(Val([original text field]))
 

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

Similar Threads

Problem with expression 7
Access 2000 Question 1
Query - Convery Text to Number in a group by 3
Data Mismatch in Excel 2010 4
How to SELECT with date criteria by SQL? 1
text conversion to number on select query 5
data type mismatch when using dates 6
Query- Type Mismatch In Expression 2

Back
Top