Welcome to SPN

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

Sign Up Now!

Entering Dates more than once in a parameter

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

  1. JamieM

    Expand Collapse

    I have the following parameter set in a query & report:

    Between [Start Date] And [End Date]

    When I try to view the Datasheet or Report, it prompts me to enter these
    dates. However, it asks me to enter these dates more than once (sometimes up
    to 3 times).

    Why does it do this and how can i fix it that I only have to enter these
    dates once?
  2. Loading...

  3. Jason

    Expand Collapse

    I am not sure why it does this but mine was doing the same thing. If
    you go into the query design screen and change the criteria to Between
    {Start Date:] And [End Date:]. It will fix the problem.

Share This Page