Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2013
    Posts
    9

    Unanswered: Append Query for date range

    I am currently trying to make an Append query that will take the Start date from one table and the end date from the same table and append all dates between those 2 into another table.

    Currently have

    INSERT INTO [Service Contract] ( [Service Start Date], [Servvice ID] )
    SELECT DoS.[DoS Start], DoS.[Service ID]
    FROM DoS;

    I can append the start date but how would I increment it to the end date

    DoS.[DoS End] is the end date

    Is there some kind of loop function I can execute?

  2. #2
    Join Date
    Nov 2011
    Posts
    413
    DteCriteria: Between [start date] And [DoS End]

Tags for this Thread

Posting Permissions

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