Results 1 to 3 of 3
  1. #1
    5 Star Lounger bfxtrfcmgr's Avatar
    Join Date
    Aug 2002
    Location
    Fresno, California, USA
    Posts
    995
    Thanks
    12
    Thanked 0 Times in 0 Posts

    Format txtbx on report (2002 SP-3)

    Hi all!

    I'm trying to return the date range of records returned in a txtbx of the report header, but am having "issues" with my formatting. This ain't workin':
    ="Requests from " & Format$(=Min[datRequestDate],"mmmmyyyy",0,0) & " To " & Format$(=Max[datRequestDate],"mmmmyyyy",0,0) & " (by month)"
    Little help?
    Bryan,
    Not the smartest critter on the glacier. . .
    . . .but I'm persistent (does that count?)

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

    Re: Format txtbx on report (2002 SP-3)

    You shouldn't have = before Min and Max, only at the beginning of the entire expression.
    Min and Max are functions, they expect the argument to be enclosed in parentheses ( ).
    You don't need the 3rd and 4th argument to Format here, they are only needed if you're dealing with days of the week or weeks of the year.

    ="Requests from " & Format$(Min([datRequestDate]),"mmmmyyyy") & " To " & Format$(Max([datRequestDate]),"mmmmyyyy") & " (by month)"

  3. #3
    5 Star Lounger bfxtrfcmgr's Avatar
    Join Date
    Aug 2002
    Location
    Fresno, California, USA
    Posts
    995
    Thanks
    12
    Thanked 0 Times in 0 Posts

    Re: Format txtbx on report (2002 SP-3)

    Thanks Hans!

    <img src=/S/brickwall.gif border=0 alt=brickwall width=25 height=15> I would have bet money that I tried that, but got errors. I've started pasting my attempts to notepad so I can look back to see where I went wrong after getting bailed out by the Lounge. In this case, seems like "...$(Min([datRequestDate..." works much better that "...$(Min[datRequestDate..."
    Thanks again!
    Bryan,
    Not the smartest critter on the glacier. . .
    . . .but I'm persistent (does that count?)

Posting Permissions

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