Results 1 to 3 of 3
  1. #1
    Silver Lounger
    Join Date
    Jun 2001
    Location
    Niagara Falls, New York, USA
    Posts
    1,878
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Print 1st, 2nd, 3rd, 4th, etc on Report? (a2k (9.0.6926) SP-3 Jet 4.0 SP-8

    I have the following code in report module

    <pre>Paragraph5 = _
    Trim(Forms(gloGetValue("ParentFormName")).strOwner Name) & _
    ", on the " & _
    Format(Forms(gloGetValue("ParentFormName")).[dtm1stInspDate], "d") & _
    " day of " & _
    Format(Forms(gloGetValue("ParentFormName")).[dtm1stInspDate], "mmmm") & _
    ", " & _
    Format(Forms(gloGetValue("ParentFormName")).[dtm1stInspDate], "yyyy") & _
    " at " & _
    Forms(gloGetValue("ParentFormName")).[strCRLocation] & _
    " in the" & _
    GetPref("Municipality") & _
    ", County of " & _
    GetPref("County Name") & _
    ", " & _
    GetPref("Municipality State Name") & _
    ", did committ this offence of " & _
    DLookup("[strDescription]", _
    "[tbl_CR_ViolType]", _
    "[lngViolTypeID] = report![lngViolTypeID]") _
    & vbCr + vbLf + vbCr + vbLf
    </pre>


    The out put is this:

    HENNINGER WILLIAM - MARY, on the 1 day of June, 2004 at BAER 6192 in theTown of Wheatfield,
    County of Niagara, New York, did committ this offence of REFUSE DISPOSAL (DUMPING)

    What is the best way to add code so it prints 1st day of June, 2004, or 2nd day of June, 2004, etc?

    Thanks, John

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

    Re: Print 1st, 2nd, 3rd, 4th, etc on Report? (a2k (9.0.6926) SP-3 Jet 4.0

    See <post#=370724>post 370724</post#> by MarkD.

  3. #3
    Silver Lounger
    Join Date
    Jun 2001
    Location
    Niagara Falls, New York, USA
    Posts
    1,878
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Print 1st, 2nd, 3rd, 4th, etc on Report? (a2k (9.0.6926) SP-3 Jet 4.0

    Thanks Hans for finding and MarkD for providing

Posting Permissions

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