Home > IT Answers > Database > Problems with VAL function
Arlin
70 pts.
 Problems with VAL function
Access reports, Microsoft Access, VAL Function
I have a table with an NVarChar field that contains left aligned numeric values. I've tried using the VAL function to return the integer values, but I'm getting back Short Date results. What can I do to get integer results? Thanks, Arlin

Software/Hardware used:
ASKED: February 9, 2009  4:33 PM
UPDATED: February 17, 2009  11:32 PM
RELATED QUESTIONS
Answer Wiki:
Choose an appropriate format for this field.
Last Wiki Answer Submitted:  February 10, 2009  5:49 pm  by  msi77   1,610 pts.
All Answer Wiki Contributors:  msi77   1,610 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

I agree with the recommendation.
Open the table in Design mode; Choose Data Type as Integer; Under Field Properties>> Field size As Long Integer.
Good luck

SbElectric
 2,510 pts.
 

I ended up using the following in my query:

Expr2: CInt([Table_Field])

Worked fine.

Thanks,
Arlin

Arlin
 70 pts.