Results 1 to 3 of 3
  1. #1
    maximutt is offline Novice
    Windows 98/ME Access 97
    Join Date
    Aug 2011
    Posts
    1

    Automatically run a query

    Hi,



    i need to run the same query for each day of the month and have an output table with the information from each day showing

    can someone help?

  2. #2
    Robeen is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    Mar 2011
    Location
    Tulsa, Oklahoma.
    Posts
    1,593
    What are the fields in your tables that you're getting your data from & what data needs to go into your output table?

    If you're running the query against the same table[s], it might be possible to just sort by Date. Would that fulfil your requirements?

  3. #3
    rpeare is offline VIP
    Windows XP Access 2003
    Join Date
    Jul 2011
    Posts
    5,441
    Why do you need to output data that you're already storing into a secondary table?

    It should be possible to build a query that shows you the information you want without storing anything.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Automatically Update Query Parameter w/ Code
    By benthamq in forum Programming
    Replies: 2
    Last Post: 08-20-2011, 03:46 PM
  2. Run Make Table query automatically
    By tuna in forum Queries
    Replies: 5
    Last Post: 05-10-2010, 03:15 AM
  3. Help Automatically running and Update Query
    By JohnRandolphSTL in forum Queries
    Replies: 8
    Last Post: 04-13-2010, 02:08 PM
  4. I want to automatically pass a value to a query
    By Slategrey252 in forum Queries
    Replies: 1
    Last Post: 10-01-2009, 05:38 AM
  5. Replies: 0
    Last Post: 07-30-2009, 12:40 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums