Results 1 to 3 of 3
  1. #1
    ChristopherL is offline Novice
    Windows XP Access 2002
    Join Date
    Jul 2013
    Posts
    18

    Save query!


    Hi!
    I have just finished a report that saves values in a query.
    This query contains values that change for each day, so what I would like to do is create a way to store this informaton in another query.

    Basically I'd like to save data for each report-date.
    And if you run the macro the same day I want it to replace that info with the new one.

    So -> Save data for each day report date, if run on the same day then replace, and the next day append that for the new report date.

    So it stores data for each report date

    Anyone know a good structure with delete/append querys?

  2. #2
    orange's Avatar
    orange is offline Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,848
    When you post on multiple forums (Cross Post, please indicate that to the readers and include a link.
    http://www.access-programmers.co.uk/...d.php?t=249706

    Here is the rationale
    http://www.excelguru.ca/content.php?...-cross-posters

  3. #3
    ChristopherL is offline Novice
    Windows XP Access 2002
    Join Date
    Jul 2013
    Posts
    18
    Ahh I am terribly sorry for that, next time i'll definetly follow that agenda!
    Really believe that both of these forums are great and provide the information that I need!
    Solved this problem on my own tho, but thanks for taking your time!

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

Similar Threads

  1. Replies: 3
    Last Post: 10-08-2012, 08:40 AM
  2. Replies: 8
    Last Post: 09-27-2012, 11:12 AM
  3. Need help to save query.
    By Acc4me in forum Access
    Replies: 2
    Last Post: 07-15-2012, 06:22 PM
  4. Replies: 10
    Last Post: 06-20-2012, 09:50 AM
  5. Replies: 9
    Last Post: 01-20-2011, 02:22 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