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

    wnfisba
    Expand Collapse
    Guest

    Aaron,

    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?

    Thanks.

    wnfisba

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


Share This Page