Which wildcard to be used to display 2 digit numbers

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • shalskedar
    New Member
    • Sep 2009
    • 66

    Which wildcard to be used to display 2 digit numbers

    In my Database for 1 of the fields as "ID "
    i need to display the criteria as

    10/2...followed by some characters till 90/2---

    for ex-10/2001
    11/2008
    ----
    ----
    90/2005

    So what criteria/wildcard i use for the above numbers..
    The "ID" starts with 2 digit number as 10,11---90..

    Can anyone Plz help me with this..

    Thanks..
  • Jerry Maiapu
    Contributor
    • Feb 2010
    • 259

    #2
    I cannot really understand you question. Please try and rephrase the question.

    Firstly:
    I understand that you trying to generate a number of values based on the ID? kind of a sequence..
    Secondly: Are you trying to achieve it using a query form or report.?

    Explain what you are trying to achieve and where you want it to display the result in query/form/report etc..

    Cheers!

    Comment

    • shalskedar
      New Member
      • Sep 2009
      • 66

      #3
      I need to display the result in query..

      Comment

      • Jerry Maiapu
        Contributor
        • Feb 2010
        • 259

        #4
        SORRY FOR NOT REPLYING SO SOON. i WAS AWAY. Just need more clarification. In this post : "10/2...followed by some "characters till 90/2---

        it means.. a/b. b is constant.. (i.e 90/2).

        Where will the valuers of a and b come from? .
        From a field value?

        Comment

        Working...