I need to insert the equivalent of the following formula into an Access DB.
Excel: =Left(cell,3)
Access: Left(BillingReference,3)
I am looking to pull the first 3 numbers from the value in the field BillingReference into the field Acct.
Jim O
Excel formula to Access
Competent Performer
Windows 10 
Access 2010 64bit
I need to insert the equivalent of the following formula into an Access DB.
Excel: =Left(cell,3)
Access: Left(BillingReference,3)
I am looking to pull the first 3 numbers from the value in the field BillingReference into the field Acct.
Jim O
Who is John Galt?
Windows XP Access 2007
The formula looks correct; what are you having trouble with? I wouldn't save the value if it's always the left 3.
Competent Performer
Windows 10 Access 2010 64bit
I am very new to Access and I was just having an issue finding my way around. I have it working now. It is a slow learning curve.
Jim O
Translating Excel formula to Access formula (in query)
set excel formula from access vba
Posting Permissions
Reply With Quote