Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2004
    Posts
    6

    Question Unanswered: Want to default value to zero if negative

    Hello,
    I am setting up a query and want to default a value to zero if it is a negative number, but leaving it alone if postitive. Please tell me what I need to do and where it needs to go.
    Many thanks,
    Sheila1971
    PS. No VB code please - am doing this in query view only.

  2. #2
    Join Date
    May 2004
    Posts
    17
    Try:

    Code:
    IIf([tblTable].[Field]<0, 0, [tblTable].[Field])
    in the Field line of the query design grid.

    Regards,
    Stephen.

  3. #3
    Join Date
    Jul 2004
    Posts
    6

    Smile Thanks Stephen!

    Many thanks Stephen!

    Sheila.

Posting Permissions

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