Results 1 to 2 of 2

Thread: Pls Help Me

  1. #1
    Join Date
    Oct 2002

    Angry Unanswered: Pls Help Me

    Please help me urgent
    1, I want to input data to sub form each time 8 record and if not enough 8 record user can’t exit this form.
    2, On the report I don’t know how to print out Blank Character for zero value

  2. #2
    Join Date
    Aug 2002
    Québec, Canada
    You can use the RecordCount and see if it is a multiple of 8 (thought I don't know if I've well undestand the question )

    For your report, use an IIF() statement. You can use it on the TEXTBOX in the report or in the query:

    IIF(field1 <>0, field1, "")
    IIF description
    IIF(condition, true part, false part)

    JefB - hope it helps

Posting Permissions

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