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

    JamieM
    Expand Collapse
    Guest

    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

    Jason
    Expand Collapse
    Guest

    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