Converting a String to a Int within a Query

[Shikha Gambhir]

How do I do this.....

???

Thanks
Shikha

[Allen Browne]

Use the Val() function, e.g.:
Val(Nz([MyTextField], ""))

That returns a double.
You can then wrap the entire expression in CInt() or CLng() to get an
integer or long.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Shikha Gambhir" <sh*******@gmail.com> wrote in message
news:92**************************@posting.google.c om...

How do I do this.....

???

Thanks
Shikha