Mike J Posted February 12, 2007 Share Posted February 12, 2007 I have3 a match field that I would like user's to type in a Puchase Order # so they can filter to a specific order when we receive a product from a vendor. I'm familiar with the High/Low filter when it comes to names gMatch_Name = Col... (User input) High_Name = Colzzz (Calc Field) Low_Name = Colaaa (Calc Field) How do you do it with numbers? Would it be: Note(PO# are 6 digits) gMatch = 134... High = 134999 Low = 134000 What happens if they type four numbers? gMatch = 1347.. High = 1347999 Low = 1347000 This then exceeds the character number, will this cause my high/low filter to not see the extra character? Do I need to create some sort of calc that counts the number of characters in my gMatch field to make it work? (Not sure about this because I need the first question to work before I answer the second question). Thank for the input. MJ Link to comment Share on other sites More sharing options...
comment Posted February 12, 2007 Share Posted February 12, 2007 (edited) PO# are 6 digits And what is the lowest PO#? Is it 000001 or 1000001 (or something else)? Also, is the PO# field a number or text? Edited February 12, 2007 by Guest Link to comment Share on other sites More sharing options...
Mike J Posted February 12, 2007 Author Share Posted February 12, 2007 (edited) They are always 6 digits at this point. Never lower but could be higher once we get to 999999. RIght now we are in the 6XXXXX numbers. Anything previously put into another system will not be included in my database. Oh..my ordering database you helped me with making the ERD is almost done and would like to send it to you (since you've commented on it previously) for some critique and suggestions. Can I send it to you privately? Thanks!!! MJ Edited February 12, 2007 by Guest Link to comment Share on other sites More sharing options...
comment Posted February 12, 2007 Share Posted February 12, 2007 Uhm... could you read my questions again? Link to comment Share on other sites More sharing options...
Mike J Posted February 12, 2007 Author Share Posted February 12, 2007 Number Field at the moment. Letter are not part of the PO number and to my knowledge they won't integrate text into PO# Sorry Link to comment Share on other sites More sharing options...
comment Posted February 12, 2007 Share Posted February 12, 2007 I still don't know what's your lowest PO#. I am assuming (PO# being a number field) that numbers start at 100000, and there are no PO#s with leading zeros. If so, you could use: Low = Left ( gMatch & "000000" ; 6 ) High = Left ( gMatch & "999999" ; 6 ) Link to comment Share on other sites More sharing options...
Mike J Posted February 12, 2007 Author Share Posted February 12, 2007 Thanks for pointing me in the right direction...making it a text field made all the difference. MJ Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6297 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