sammers101
Registered User.
- Local time
- Today, 07:51
- Joined
- May 11, 2012
- Messages
- 89
I have a query that takes a text field and removes "#" leaving just a number
Number:Right([issue],Len([issue])-1)
Then I made another query trying to use the max total of this number, it works except for it is returning 8 as a max instead of 10. It's not seeing 8 as 08.
It seems like it is having to do with format so I tried
Format(Right([issue],Len([issue])-1),"Standard") but that did not make a difference.
Number:Right([issue],Len([issue])-1)
Then I made another query trying to use the max total of this number, it works except for it is returning 8 as a max instead of 10. It's not seeing 8 as 08.
It seems like it is having to do with format so I tried
Format(Right([issue],Len([issue])-1),"Standard") but that did not make a difference.