Equivilant Function

  • Thread starter Thread starter doodle
  • Start date Start date
D

doodle

Access 97
Windows xp

I have a function that returns a number. I need to group by average but
I am getting a message that it is the wrong data type.

In Excel, there is a "Value" function that will convert a number shown
as text to a number format. Is there such a function in Access?

-doodle
 
Correction - it isn't really a "function", it is a nested Iif
statement.

-doodle
 
Doodle,
Val(yourstringvalue) would return the numeric value of a "text" number.
 
You must log in or register to reply here.

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

Is there a function "Is Numeric" 7
SQL Birthday problem ;) 8
User Defined Data Type 4
Which is the best MBOX Converter Tool different formats conversion? 5
Excel Repeating a RAND() function under certain conditions 0
How to create a VBA function which can be used within a query 11
convert Excel VBA function to Access VBA? 14
sql string 1

Back
Top