Filter on form

deepbluedeepblue Member Posts: 152
Hello!

I have a card form based on a table that have as primary key a code type field. when i run the form i want to have only the recors that have length = 8. How could I do it??

Thank you!!!

Comments

  • kinekine Member Posts: 12,562
    you can do it like filter for example "?????????".... :-)
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • deepbluedeepblue Member Posts: 152
    Excuse me Kine but I don't understund you!!! :oops:

    I want to always have only the records with a length code = 8 !
  • kinekine Member Posts: 12,562
    If you set filter ???????? (8x?) on the code, you will have just codes with length 8. ? means any character. If you have 8 x ? you have filter for "any code which have 8 characters".
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
Sign In or Register to comment.