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. OP

    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.
Since you're here... we have a small favor to ask...     Become a Supporter      ::     Make a Contribution     

Share This Page