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

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, 200718 yr by Guest

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, 200718 yr by Guest

Uhm... could you read my questions again?

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

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 )

Thanks for pointing me in the right direction...making it a text field made all the difference.

MJ