Results 1 to 5 of 5
  1. #1
    Join Date
    Oct 2004
    Posts
    7

    Question Unanswered: I enter a date range to/from from query, how do I get that date range print in report

    I'm pretty new to access, so any help please be very detalied (thanks in advance)
    I have created a query that asks for to/from date ranges. Linked a report to that query and it gives me all the data I want. Only thing, I would like the report to show me the date ranges I requested so that when I print the report it shows which dates the information is referring to. Any help is greatly appreciated.

  2. #2
    Join Date
    Sep 2003
    Location
    MN US
    Posts
    313
    Sounds like you're using parameters in a query (rather than displaying the dates in a form). What you're asking for is straightforward either way...

    Using parameters:

    Create 2 textboxes and set control source to the parameter fields. One for [start_date] and one for [end_date] (or whatever you called them)

    Using controls on a form:

    Create 2 textboxes with something like this: "=Forms!yourForm!yourControl.value"

    hth,

    Chris

  3. #3
    Join Date
    Sep 2004
    Location
    Charlotte, NC
    Posts
    164
    I assume that your query has undefined parameters such as [Enter From Date] and [Enter To Date] that require input when the query is run and since the report is based off of this query, these parameters must be defined when you run the report.

    The way that I show the dynamic values is by putting a text box in the header of the report with the following code in the Control Source in the Properties Box:
    ="FROM "&[Enter From Date]&" THRU "&[Enter To Date]

    TD

    "Conscience is the inner voice which warns us that someone may be looking." - Henry Louis Mencken

  4. #4
    Join Date
    Dec 2003
    Location
    Dallas, TX
    Posts
    1,004
    Good morning sib2,

    Just wanted to say Welcome to the Forum and that buckeye_td is absolutely correct.

    have a nice day,
    Bud

  5. #5
    Join Date
    Oct 2004
    Posts
    7
    buckeye_td, your example worked perfectly and was extremely easy to follow and understand. Thank you very much to everyone that helped on this.
    You will definately be seeing more questions from me. Thanks again. you saved me many hours of frustration.

Posting Permissions

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