Welcome to SPN

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

Sign Up Now!

RE: Passing Parameters To A Pass Through Query

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

  1. wnfisba

    Expand Collapse


    I hope I can contact you regarding this.

    I need to create an Access Pass-Through SQL Query which prompts the user for
    a beginning and end date. It looks and sounds and reads like you have
    mastered this. Could you please reply back if you have?



    "Franky Anzoletti" wrote:

    > I am making an Access application that uses a button in a form to run a pass
    > through query. The user will define a date range - StartDate, EndDate in the
    > form then press the button to run the query. The problem is: how to pass
    > these two parameters to the query which has a date range statement as follows:
    > WHERE N.INIT_DT >= '2004/07/01' (DATE, FORMAT 'YYYY/MM/DD') AND
    > N.INIT_DT <= '2005/03/25' (DATE, FORMAT 'YYYY/MM/DD')
    > Thanks in advance.
  2. Loading...

Since you're here... we have a small favor to ask...     Become a Supporter      ::     Make a Contribution     

Share This Page