Results 1 to 7 of 7
  1. #1
    Join Date
    Nov 2006
    Posts
    6

    Unanswered: Append Query Problems

    Hi

    I am doing an A level database project. I need to build a system to deal with ordering and selling products.

    I am trying to make an append query that will append all the products bought in my "invoices" table to my "archive" table. I want invoices that are three months old to be transferred the the "archive" table. I have been trying to put a criteria in the query for the Date field but I haven't managed to find an expression that works.

    I'm sorry if this is too simple and you guys think im just being stupid.
    I figured it was worth asking on here!! It's really bugging me.

  2. #2
    Join Date
    Jan 2004
    Location
    In a large office with bad lighting
    Posts
    1,040
    Show us what you got so far. Also ... look up dateadd and datediff in BOL.

    -- This is all just a Figment of my Imagination --

  3. #3
    Join Date
    Nov 2006
    Posts
    6
    Sorry, what is BOL?
    "Date"<=#01/01/2006#

    Is that what you mean by show? I don't know how to show the whole query :-s

  4. #4
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Can you write a SELECT statement to retrieve the rows that you want to archive?

    -PatP

  5. #5
    Join Date
    Nov 2006
    Posts
    6
    Thanks but I don't know what a select statement is! Is it the same as a select query? there's something about that in one of my books.

  6. #6
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,799
    Provided Answers: 11
    Is this project in Access? You may need to ask over in the Access forum...

  7. #7
    Join Date
    Nov 2006
    Posts
    6
    Yes it is. I realised after I posted here that there is an access forum too. I have posted in there now 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
  •