Welcome to SPN

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

Sign Up Now!

Flagging Dates in a Report

Discussion in 'Information Technology' started by Jennifer Cali, Jul 28, 2006.

  1. Jennifer Cali

    Jennifer Cali
    Expand Collapse
    Guest

    Hello,
    I have a database that houses all the upcoming movie release dates that we
    want to see. I have a report that sorts movies by type (horror, action, etc.)
    and then shows the movies within that category ordered by date of release. I
    wanted to see if I could, on the report, have a graphic (or something!)
    appear beside the dates that were within one week of the system date. I know
    when I write SQL at work, the SQL would be something like:

    SELECT A. BIRTHDAY
    FROM tblCONTACTS
    WHERE A.BIRTHDAY >= (SYSDATE - 7)

    This would pull any dates that were within seven days of running the report.
    I want, however, ALL movies to appear but just have some "special"
    differentiation for those being released within the week, such as a bold
    font, a graphic beside the name, etc. Can I do this? If so, how?

    --
    Thank you! - Jennifer
     
  2. Loading...

    Similar Threads Forum Date
    Sikh News BREAKING: Young Sikh Shot Dead In Jalalabad, Afghanistan . - Sikh24 News & Updates Breaking News Oct 2, 2016
    Pacific Oil slicks spotted in search for missing Malaysia Airlines plane (Live updates) Breaking News Mar 8, 2014
    India Candidates flock to Dera Sacha Sauda Breaking News Jan 17, 2012
    India Seven SAD Candidates of SGPC Win Unopposed Breaking News Aug 27, 2011
    GurmatChanan Updates Gurbani Download Aug 27, 2011

  3. fredg

    fredg
    Expand Collapse
    Guest

    On Mon, 22 May 2006 17:07:01 -0700, Jennifer Cali wrote:

    > Hello,
    > I have a database that houses all the upcoming movie release dates that we
    > want to see. I have a report that sorts movies by type (horror, action, etc.)
    > and then shows the movies within that category ordered by date of release. I
    > wanted to see if I could, on the report, have a graphic (or something!)
    > appear beside the dates that were within one week of the system date. I know
    > when I write SQL at work, the SQL would be something like:
    >
    > SELECT A. BIRTHDAY
    > FROM tblCONTACTS
    > WHERE A.BIRTHDAY >= (SYSDATE - 7)
    >
    > This would pull any dates that were within seven days of running the report.
    > I want, however, ALL movies to appear but just have some "special"
    > differentiation for those being released within the week, such as a bold
    > font, a graphic beside the name, etc. Can I do this? If so, how?


    If you have Access 2000 or newer, use the control's Conditional
    Formatting property.
    Select that control.
    Click on Format + Conditional Formatting
    Set the Condition1 Drop-down to
    Expression Is
    in the dialog box, write:
    [YourDateField] Between Date() and Date()-7

    Set the Format however you wish.

    Change [YourDateField] to whatever the actual Date field name is.
    --
    Fred
    Please respond only to this newsgroup.
    I do not reply to personal e-mail
     
  4. Pieter Wijnen

    Pieter Wijnen
    Expand Collapse
    Guest

    sure use the detail format event

    ie
    private sub detail_format(FormatCount as integer, cancel As integer
    if me.relasedate<date() -7 then
    me.title.FontBold = True
    else
    me.title.FontBold = False
    end if
    end sub

    see www.mvps.org/access or www.lebans.com (& others for more)

    HTH

    Pieter

    "Jennifer Cali" <JenniferCali@discussions.microsoft.com> wrote in message
    news:2FD0A287-7E0B-4946-8243-A385F3004058@microsoft.com...
    > Hello,
    > I have a database that houses all the upcoming movie release dates that we
    > want to see. I have a report that sorts movies by type (horror, action,
    > etc.)
    > and then shows the movies within that category ordered by date of release.
    > I
    > wanted to see if I could, on the report, have a graphic (or something!)
    > appear beside the dates that were within one week of the system date. I
    > know
    > when I write SQL at work, the SQL would be something like:
    >
    > SELECT A. BIRTHDAY
    > FROM tblCONTACTS
    > WHERE A.BIRTHDAY >= (SYSDATE - 7)
    >
    > This would pull any dates that were within seven days of running the
    > report.
    > I want, however, ALL movies to appear but just have some "special"
    > differentiation for those being released within the week, such as a bold
    > font, a graphic beside the name, etc. Can I do this? If so, how?
    >
    > --
    > Thank you! - Jennifer
     
  5. Jennifer Cali

    Jennifer Cali
    Expand Collapse
    Guest

    Pieter,
    Where would I enter this in? Specifically, where on the report would I find
    the detail format event? Your coding below seems to make sense to me. Also,
    though, where would the closed ")" go in your code below? I see an open "("
    on the first line but no closed ")" to complete the statement. I greatly
    appreciate your help!

    --
    Thank you! - Jennifer


    "Pieter Wijnen" wrote:

    > sure use the detail format event
    >
    > ie
    > private sub detail_format(FormatCount as integer, cancel As integer
    > if me.relasedate<date() -7 then
    > me.title.FontBold = True
    > else
    > me.title.FontBold = False
    > end if
    > end sub
    >
    > see www.mvps.org/access or www.lebans.com (& others for more)
    >
    > HTH
    >
    > Pieter
    >
    > "Jennifer Cali" <JenniferCali@discussions.microsoft.com> wrote in message
    > news:2FD0A287-7E0B-4946-8243-A385F3004058@microsoft.com...
    > > Hello,
    > > I have a database that houses all the upcoming movie release dates that we
    > > want to see. I have a report that sorts movies by type (horror, action,
    > > etc.)
    > > and then shows the movies within that category ordered by date of release.
    > > I
    > > wanted to see if I could, on the report, have a graphic (or something!)
    > > appear beside the dates that were within one week of the system date. I
    > > know
    > > when I write SQL at work, the SQL would be something like:
    > >
    > > SELECT A. BIRTHDAY
    > > FROM tblCONTACTS
    > > WHERE A.BIRTHDAY >= (SYSDATE - 7)
    > >
    > > This would pull any dates that were within seven days of running the
    > > report.
    > > I want, however, ALL movies to appear but just have some "special"
    > > differentiation for those being released within the week, such as a bold
    > > font, a graphic beside the name, etc. Can I do this? If so, how?
    > >
    > > --
    > > Thank you! - Jennifer

    >
    >
    >
     
  6. Jennifer Cali

    Jennifer Cali
    Expand Collapse
    Guest

    Hi Fred,
    I'll have to remember this for when I upgrade; unfortunatly, I don't have
    2000 or newer. Bummer. It sounds very straight forward; thanks for your reply!
    --
    Thank you! - Jennifer


    "fredg" wrote:

    > On Mon, 22 May 2006 17:07:01 -0700, Jennifer Cali wrote:
    >
    > > Hello,
    > > I have a database that houses all the upcoming movie release dates that we
    > > want to see. I have a report that sorts movies by type (horror, action, etc.)
    > > and then shows the movies within that category ordered by date of release. I
    > > wanted to see if I could, on the report, have a graphic (or something!)
    > > appear beside the dates that were within one week of the system date. I know
    > > when I write SQL at work, the SQL would be something like:
    > >
    > > SELECT A. BIRTHDAY
    > > FROM tblCONTACTS
    > > WHERE A.BIRTHDAY >= (SYSDATE - 7)
    > >
    > > This would pull any dates that were within seven days of running the report.
    > > I want, however, ALL movies to appear but just have some "special"
    > > differentiation for those being released within the week, such as a bold
    > > font, a graphic beside the name, etc. Can I do this? If so, how?

    >
    > If you have Access 2000 or newer, use the control's Conditional
    > Formatting property.
    > Select that control.
    > Click on Format + Conditional Formatting
    > Set the Condition1 Drop-down to
    > Expression Is
    > in the dialog box, write:
    > [YourDateField] Between Date() and Date()-7
    >
    > Set the Format however you wish.
    >
    > Change [YourDateField] to whatever the actual Date field name is.
    > --
    > Fred
    > Please respond only to this newsgroup.
    > I do not reply to personal e-mail
    >
     
  7. Pieter Wijnen

    Pieter Wijnen
    Expand Collapse
    Guest

    select the detail section /properties/Events/OnFormat/Code Builder

    Pieter

    "Jennifer Cali" <JenniferCali@discussions.microsoft.com> wrote in message
    news:6470C53C-4908-45C4-A056-B365289B8BB5@microsoft.com...
    > Pieter,
    > Where would I enter this in? Specifically, where on the report would I
    > find
    > the detail format event? Your coding below seems to make sense to me.
    > Also,
    > though, where would the closed ")" go in your code below? I see an open
    > "("
    > on the first line but no closed ")" to complete the statement. I greatly
    > appreciate your help!
    >
    > --
    > Thank you! - Jennifer
    >
    >
    > "Pieter Wijnen" wrote:
    >
    >> sure use the detail format event
    >>
    >> ie
    >> private sub detail_format(FormatCount as integer, cancel As integer
    >> if me.relasedate<date() -7 then
    >> me.title.FontBold = True
    >> else
    >> me.title.FontBold = False
    >> end if
    >> end sub
    >>
    >> see www.mvps.org/access or www.lebans.com (& others for more)
    >>
    >> HTH
    >>
    >> Pieter
    >>
    >> "Jennifer Cali" <JenniferCali@discussions.microsoft.com> wrote in message
    >> news:2FD0A287-7E0B-4946-8243-A385F3004058@microsoft.com...
    >> > Hello,
    >> > I have a database that houses all the upcoming movie release dates that
    >> > we
    >> > want to see. I have a report that sorts movies by type (horror, action,
    >> > etc.)
    >> > and then shows the movies within that category ordered by date of
    >> > release.
    >> > I
    >> > wanted to see if I could, on the report, have a graphic (or something!)
    >> > appear beside the dates that were within one week of the system date. I
    >> > know
    >> > when I write SQL at work, the SQL would be something like:
    >> >
    >> > SELECT A. BIRTHDAY
    >> > FROM tblCONTACTS
    >> > WHERE A.BIRTHDAY >= (SYSDATE - 7)
    >> >
    >> > This would pull any dates that were within seven days of running the
    >> > report.
    >> > I want, however, ALL movies to appear but just have some "special"
    >> > differentiation for those being released within the week, such as a
    >> > bold
    >> > font, a graphic beside the name, etc. Can I do this? If so, how?
    >> >
    >> > --
    >> > Thank you! - Jennifer

    >>
    >>
    >>
     

Share This Page