Results 1 to 2 of 2
  1. #1
    Star Lounger
    Join Date
    Sep 2002
    Location
    Edmonton, Alberta
    Posts
    92
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Access Query (Access 2003)

    I have set up a parameter query with a Between Start & End date. That works fine - except I need the end date to become a field in my query. I tried this with the Between, then 2 new fields Start & End - it now asks me 4 times for the Start & End date.
    Thank you in advance.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 18 Times in 18 Posts

    Re: Access Query (Access 2003)

    The screenshot below shows a way to do this. The parameter prompts will be for Start Date and Last Date, the query will have a column named End Date.
    Attached Images Attached Images
    • File Type: png x.png (2.1 KB, 0 views)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •