Results 1 to 4 of 4
  1. #1
    Join Date
    Jul 2012
    Location
    Arizona
    Posts
    4

    Unanswered: New to Forum and need help with Access Form

    Good morning,

    I have 10 queries that each require a date range (>=5/1/2012 AND <=5/31/2012). This will obviously change each month and I do not want to go into each query and change this. Is there someway I can setup this range, maybe in a form, so that I can change just the form and it will automatically populate each criteria field in the queries? I'm using Access 2007.
    Last edited by dash11; 07-03-12 at 14:42. Reason: SOLVED

  2. #2
    Join Date
    May 2005
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6

  3. #3
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Oops, sorry... That was my bad when I moved this thread from New Users to MS-Access without checking for a duplicate thread.

    -PatP
    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

  4. #4
    Join Date
    May 2005
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6
    40 lashes with a wet noodle!
    Paul

Posting Permissions

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