Results 1 to 13 of 13
  1. #1
    New Lounger
    Join Date
    Apr 2003
    Location
    Washington, USA
    Posts
    24
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Date Range Report (97)

    I have set up DB and want to preview reports based on a date range from a form (ie, Date Range Form).
    The problem is I can't seem to have it show only the date ranges identified and am wondering what I'm doing wrong.
    I can do this in a query but this DB is for someone not familiar with that type of format. I just want them to be able to type in the dates and see the report.

    Thanks for any advice....

  2. #2
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Date Range Report (97)

    If you do it in the query then base the report on the query this will work just fine.

    Pat

  3. #3
    New Lounger
    Join Date
    Apr 2003
    Location
    Washington, USA
    Posts
    24
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Date Range Report (97)

    But won't you have to redo the query every time the date range changes?

  4. #4
    New Lounger
    Join Date
    Apr 2003
    Location
    Washington, USA
    Posts
    24
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Date Range Report (97)

    Sorry, need to add on. The person using this doesn't know how to do this so I want to make it as simple as possible. Thanks

  5. #5
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Date Range Report (97)

    In your query you speicify the date range by Between Forms![your form name]!StartDate and Forms![your forma name]!EndDate.
    Your form has these 2 dates specified.
    Your report should then use the query as the source of the report.
    The user would then just enter the dates on the form and press a button to see the report. What could be more simple.
    If you need any more details, please post back.


    Pat

  6. #6
    Silver Lounger
    Join Date
    Jun 2002
    Location
    Cheadle, Staffordshire
    Posts
    2,177
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Date Range Report (97)

    Just to further Patt's advice:

    In the underlying query, where you have the date field from which you specify your reports parameters (Date criteria)
    use the following statement:

    >=[StartDate] And <=[EndDate]

    In your reports header you can then create two unbound texts with a specified control source:

    Unbound1, control source [StartDate]
    Unbound2, control source [EndDate]

    By this when previewing or printing the report, the date range as specified will show on the report.

  7. #7
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Date Range Report (97)

    She could do it the way you have described but I think what she wants is to keyin the dates on the form rather than have them be entered as parameters in the query.

    She can show the range of dates in the report header by putting the following in an anbound text box:
    ="Between " & Forms![her form name]!StartDate & " and " & Forms![her form name]!EndDate

  8. #8
    Silver Lounger
    Join Date
    Jun 2002
    Location
    Cheadle, Staffordshire
    Posts
    2,177
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Date Range Report (97)

    Patt
    Thanks for the update.
    I had realised this after re-reading the post.

  9. #9
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Newbury, Berkshire, England
    Posts
    712
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Date Range Report (97)

    <A target="_blank" HREF="http://www.colbyconsulting.com/">This is a ready made form for handling date ranges (A2000) Click on the "Withevents Demo" button to go to it
    </A>
    Extract:::
    DateRangeWithEvents.zip This is a useful demo that uses Withevents to select a date range such as "current month", "Current Quarter" etc. from a combo. The AfterUpdate is handled in the class to set FromDate and ToDate text boxes with the resulting dates. This will be used for filters for queries.

  10. #10
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Date Range Report (97)

    13 days to go until "inevitability"

  11. #11
    4 Star Lounger
    Join Date
    Jun 2001
    Location
    Sacramento, California, USA
    Posts
    491
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Date Range Report (97)

    OK patt - I'm game <img src=/S/surrender.gif border=0 alt=surrender width=31 height=23>
    "13 days to go until "inevitability"

    Please tell <img src=/S/igiveup.gif border=0 alt=igiveup width=31 height=23>

    Michael

  12. #12
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Date Range Report (97)

    The Matrix Reloaded, of course!!

  13. #13
    4 Star Lounger
    Join Date
    Jun 2001
    Location
    Sacramento, California, USA
    Posts
    491
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Date Range Report (97)

    <img src=/S/thankyou.gif border=0 alt=thankyou width=40 height=15>

    Michael

Posting Permissions

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