Results 1 to 4 of 4

Thread: DMAX (A2002)

  1. #1
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: DMAX (A2002)

    It looks as if the last part of the line of code is missing.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: DMAX (A2002)

    Apart from my previous reply, the behavior you describe makes me suspect that EpisodeNo is a text field; it should be a number field.

  3. #3
    5 Star Lounger
    Join Date
    Feb 2001
    Location
    Louisville, Kentucky, USA
    Posts
    605
    Thanks
    0
    Thanked 0 Times in 0 Posts

    DMAX (A2002)

    Good Morning....

    I really need a suggestion here.....PLEASE!!!

    I'm using the following code to get the MAXIMUM Episode number from tblPrecert where the MaxMC No and SSN and ReviewType are equal.

    When the user needs to ADD a new Episode for the MaxMCNo, they click a button and the code runs. i.e. if the Episode No. is 9 and they click the button, they will get a NEW record and a NEW Episode No...now 10.

    It works very well.....until the new episode should be 11. It will continues to return "10" for each new Episode.

    Code:
    <hr>
    Me.txtEpisodeNo = Nz(DMax("EpisodeNo", "tblPrecert", "[SSN] = '" & Me!txtSSN & "' And [maxMCNO] = '" & Me!txtMaxMCNo & "' And [ReviewType] = " & Me!txtReviewType), 0) + 1
    <hr>



    Why won't it continue to count?.....9, 10, 11, 12, etc.

    Thanks,
    Roberta Price <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>

  4. #4
    5 Star Lounger
    Join Date
    Feb 2001
    Location
    Louisville, Kentucky, USA
    Posts
    605
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: DMAX (A2002)

    Hans,

    That's exactly what it was.....I changed Episode No FROM text TO numeric..added 6 new Episodes and it increased in value just as it was suppose to....


    Thanks so much.
    Roberta Price <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •