Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Limiting output

Discussion in 'Information Technology' started by Ernest Lai, Nov 1, 2005.

  1. Ernest Lai

    Ernest Lai
    Expand Collapse
    Guest

    I have a database which has 100's of entries. At the start of the database
    i have some information like todays date. Expr10: Format(Date(),"yyyymmdd")

    (dont ask me why its in that format, someone requested it)

    However the date is repeated in every single row that i have data. eg. i
    have 300 entries the date is repeated 300 times.

    Is there any way to have the date displayed once in the first row only?

    Any help is really appreciated and thanks in advance.
     
  2. Loading...

    Similar Threads Forum Date
    Sikh News Punjab wheat output to be highest in 7 years (Reuters via Yahoo! India News) Breaking News May 15, 2008
    Sikh News Punjab fears shortfall of 2.4m tons in wheat output (Dawn) Breaking News Apr 7, 2008
    Sikh News Punjab fastener makers trim output by 30% on rising cost (The Hindu) Breaking News Mar 10, 2008

  3. Mauricio Silva

    Mauricio Silva
    Expand Collapse
    Guest

    Hi Ernest,

    if you are talking about reports, you can turn on the property "Hide
    Duplicates" and the value will appear only once.

    Now, to do it on a form, you may need to use something else because this
    option is not available. When I did it, I had a structure like group/sub
    group, fortunately my subgroups were numbered, starting from 1 so, on the
    form, I did a Conditional Formmating, every time the subgroup number were
    <>1, foreground color = backgroup color. This option will slow your form
    performance, but will do the trick.

    Mauricio Silva


    "Ernest Lai" wrote:

    > I have a database which has 100's of entries. At the start of the database
    > i have some information like todays date. Expr10: Format(Date(),"yyyymmdd")
    >
    > (dont ask me why its in that format, someone requested it)
    >
    > However the date is repeated in every single row that i have data. eg. i
    > have 300 entries the date is repeated 300 times.
    >
    > Is there any way to have the date displayed once in the first row only?
    >
    > Any help is really appreciated and thanks in advance.
     

Share This Page