Blastbeats
Registered User.
- Local time
- Today, 12:37
- Joined
- Feb 22, 2012
- Messages
- 17
Hello Everyone
I was wondering if you know any way to substract 1 to the instr returned value inside the left function, im doing something like left ([Field],instr([field]," ")), except the instr value needs to have something like this left ([Field],instr([field]," ")-1) but access won't let me do it, im wondering if i can do this inside the whole function because they are inside a query, thanks in advance
I was wondering if you know any way to substract 1 to the instr returned value inside the left function, im doing something like left ([Field],instr([field]," ")), except the instr value needs to have something like this left ([Field],instr([field]," ")-1) but access won't let me do it, im wondering if i can do this inside the whole function because they are inside a query, thanks in advance