User Profile

Collapse

Profile Sidebar

Collapse
power2005
power2005
Last Activity: Sep 24 '07, 12:59 AM
Joined: Sep 13 '07
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • power2005
    replied to How to add a blank row in between dictinct data block in Access Report
    in Access
    Hi mmccarthy

    This is exactly what I need! Thank you very much. You made my day!

    power2005
    See more | Go to post

      Leave a comment:

    • power2005
      replied to How to add a blank row in between dictinct data block in Access Report
      in Access
      Sorry the space doesn't seem to work well... i found out that i can edit the post only after i post this, sorry...

      Data -

      Country Company
      ------- --------
      US Wal Mart
      UK Tesco
      US Exxon Mobil
      UK BP

      Report -

      Country Company
      ------- --------
      US Wal Mart
      ..... Exxon Mobil
      ...
      See more | Go to post

        Leave a comment:

      • power2005
        started a topic How to add a blank row in between dictinct data block in Access Report
        in Access

        How to add a blank row in between dictinct data block in Access Report

        Hi Experts

        I run into a problem I can't seem to be able to resolve or find the solution to. Basically I have a list of sample data as follow -

        Country Company
        ------- --------

        US Wal Mart
        UK Tesco
        US Exxon Mobil
        UK BP

        I would like to present them in a report with higher readability, so I sort by country and hide the repeated...
        See more | Go to post
        • power2005
          replied to Ignore blank search parameter with IIf statement
          in Access
          The correct syntax is

          Like IIf(IsNull([Forms]![Form1]![Text2]), "*",[Forms]![Form1]![Text2])

          instead of

          IIf(IsNull([Forms]![Form1]![Text2]), Like "*",[Forms]![Form1]![Text2]) -> Wrong!!

          I'm sorry to waste your time if you come in to help only to see I've found the solution, but hopefully this post will help someone like me who doesn't know about the correct syntax...
          See more | Go to post

            Leave a comment:

          • power2005
            replied to Ignore blank search parameter with IIf statement
            in Access
            Hi Experts

            After further trial and error I found that the problem may lie with the "*" expression as in

            IIf(IsNull([Forms]![Form1]![Text2]),"*",[Forms]![Form1]![Text2]) and
            IIf(IsNull([Forms]![Form1]![Text2]), Like "*",[Forms]![Form1]![Text2])

            i try using
            IIf(IsNull([Forms]![Form1]![Text2]),"(some entry that match)",[Forms]![Form1]![Text2])
            ...
            See more | Go to post

              Leave a comment:

            • power2005
              started a topic Ignore blank search parameter with IIf statement
              in Access

              Ignore blank search parameter with IIf statement

              Hi Experts

              I'm having a problem with IIf statement and it's driving me crazy... i'm a total newbie and i've spent hours to make it work but to no avail...

              what I'm trying to do is to have a search form with several parameters, and i want to ignore the parameter when it's blank, i tried the following criteria

              IIf(IsNull([Forms]![Form1]![Text2]),"*",[Forms]![Form1]![Text2]) and
              IIf(IsNull([Forms]![Form1]![Text2]),...
              See more | Go to post
              • power2005
                replied to Ignore Yes/No (checkboxes) when value input in text box
                in Access
                Hi Scott

                I'm really sorry. I thought since I have the same problem so I post in the related thread. Thanks for pointing out my lack of manner. I shall post a new thread!

                power2005
                See more | Go to post

                  Leave a comment:

                • power2005
                  replied to Ignore Yes/No (checkboxes) when value input in text box
                  in Access
                  Hi Scott/nickvans

                  I'm having the same problem with the IIf statement and it's driving me crazy... I've attached the mdb file at

                  http://www.mediafire.c om/?fymly9xtx0r

                  it's a very simple file with two tables, one query and one form, i'm using the button in the form to test out the IIf statement in the query. i'm a total newbie and i've spent hours to make it work but to no avail...

                  Please...
                  See more | Go to post

                    Leave a comment:

                  No activity results to display
                  Show More
                  Working...