HonkyCat Posted March 29, 2004 Share Posted March 29, 2004 Hello, I have a calculation field that is going to be used in a "send mail" script. One of the fields that needs to show up in the calculation is a number field that contains a report number (example; 04-04567). The original field displays the number correctly, but when I put that field in the calculation, it drops the zero and the dash (so it looks like 404567). I've tried putting (NumToText) in the calculation and that doesn't do the trick. Can anyone tell me how I can get the number to display correctly? Thanks in advance!! Kristine Version: v6.x Platform: Mac OS X Panther Link to comment Share on other sites More sharing options...
-Queue- Posted March 29, 2004 Share Posted March 29, 2004 Yep, change the original field to text, since report number is not a real 'number'. Link to comment Share on other sites More sharing options...
HonkyCat Posted March 29, 2004 Author Share Posted March 29, 2004 Thank you, thank you, thank you Old Hand!! Kristine Version: v6.x Platform: Mac OS X Panther Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 7347 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now