About
Pricing
Community
Teams
Start Free Trial
Log in
Amour22015
asked on
9/21/2015
MS Access Query - How to convert nvarchar to int
Hi experts,
I have a column
InvoiceNr it is a nvarchar data type
I am converting this into a int column
so something like:
CInt([InvoiceNR]) but that is for VBA
I am looking to do this using a Query
Please help and thanks...
Microsoft Access
VBA
SQL
6
1
Last Comment
Gustav Brock
8/22/2022 - Mon
Scott McDaniel (EE MVE )
9/21/2015
CINT works in a query ...
Amour22015
9/21/2015
ASKER
But when I use that I get:
#Num!
Please help and thanks...
ASKER CERTIFIED SOLUTION
Gustav Brock
9/21/2015
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Mike Eghtebas
9/21/2015
Try:
cint(Nz(InvoiceNr))
or perhaps:
IIF(IsNumeric(InvoiceNr), Cint(InvoiceNr), '')
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy
Amour22015
9/21/2015
ASKER
That works for this query thanks
Gustav Brock
9/21/2015
You are welcome!
/gustav