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

    Dynamic Parameter Query (Access 2003)

    I think that this is a really difficult solution - at least for me. I need a query / table that will.....update on a constant date.
    EX. March 30, April 30 etc. I need it to give me a count and export this to a table - is this possible?
    thanks in advance.

  2. Get our unique weekly Newsletter with tips and techniques, how to's and critical updates on Windows 7, Windows 8, Windows XP, Firefox, Internet Explorer, Google, etc. Join our 480,000 subscribers!

    Excel 2013: The Missing Manual

    + Get this BONUS — free!

    Get the most of Excel! Learn about new features, basics of creating a new spreadsheet and using the infamous Ribbon in the first chapter of Excel 2013: The Missing Manual - Subscribe and download Chapter 1 for free!

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

    Re: Dynamic Parameter Query (Access 2003)

    Please provide more detailed information. What does "give me a count" mean for example.

  4. #3
    Star Lounger
    Join Date
    Sep 2002
    Location
    Edmonton, Alberta
    Posts
    92
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Dynamic Parameter Query (Access 2003)

    Sorry for the long delay - I was so tired of working on the Database I went to bed. Here goes- I will try to explain it better.
    I have a table of items (over 6,000) that I have 3 queries counting on a Start date & End date for specific criteria for Planned, Actual and Forecast information. I then have a append query that runs the 3 counting queries and allows me to append it to a table. The only way I could get the user to put the end date in is have him go to the table and type it in. It needs to do a count from March 1 to July 30 each week from a Monday to the Sunday - ex. July 21 to July 27th. I need to hold that information (which I do in the table) and then I have it linked to excel to create a chart. I need help with 2 things. How do I get the end date into the table from the parameter query and how can I have it update the table each week but leave the dates? Hopefully this makes more sense.

  5. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 16 Times in 16 Posts

    Re: Dynamic Parameter Query (Access 2003)

    I think I answered the question how to get the parameter into the query (and hence into the table) in <post:=712,183>post 712,183</post:> which you haven't reacted to. I don't understand the main question, sorry.

  6. #5
    Star Lounger
    Join Date
    Sep 2002
    Location
    Edmonton, Alberta
    Posts
    92
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Dynamic Parameter Query (Access 2003)

    I tried your suggestion - it didn't work - I think I have to put it into all 3 queries to get it to work properly. Sorry I'm not very good at explaining. Thanks for all your help. I think I may have solved it by doing a update query instead of an append.
    Thanks

Posting Permissions

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