Results 1 to 8 of 8
  1. #1
    Join Date
    Sep 2004
    Posts
    33

    Unanswered: Simple Report Question

    I am creating a report and this reports get information from a table in the table the name of the field is "NOT"

    when generating the report if the NOT field is isn't null I want the text box to put * this sign but if it is NULL just put nothing.

    what should i enter to to the Control Source of the text field in the Report ?

    it must be simple but I am still learning

    Thanks in advance

  2. #2
    Join Date
    Jul 2003
    Location
    Michigan
    Posts
    1,941
    =Iif(Isnull([Not]),Null,"*")
    Inspiration Through Fermentation

  3. #3
    Join Date
    Sep 2004
    Posts
    33
    I am really sorry i noticed that the deafult value is 0 so if instead of NOT NULL i should use not 0 (zero)

  4. #4
    Join Date
    Sep 2004
    Posts
    33
    I am tried this but it gave me bad syntax

    =IIf(Is"0"([Not]),Null,"*")

  5. #5
    Join Date
    Jul 2003
    Location
    Michigan
    Posts
    1,941
    Use this instead

    =IIf([Not]=0,Null,"*")
    Inspiration Through Fermentation

  6. #6
    Join Date
    Sep 2004
    Posts
    33
    unfortunitally this is giving me control sorce error # but i know the report is linked to the table because when i put NOT in the control source it is giving me the NOT correctly

    but this does not seem to work =IIf([Not]=0,Null,"*")

  7. #7
    Join Date
    Jul 2003
    Location
    Michigan
    Posts
    1,941
    I think you may have something like a circular reference.
    If your fieldname in your control source is called "Not" and the
    name of the text box on your report is called "Not" also, the formula
    won't work. Change the name of the text box on the report to "txtNot",
    and then the formula should work.
    Inspiration Through Fermentation

  8. #8
    Join Date
    Sep 2004
    Posts
    33
    thank you very much it works

Posting Permissions

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