Append table with the previous week data and the current data

[Shamli]

How to append a table with User's input from the previous week data and the current data.



Main table has the data from the starting week to the current week .
But I have to create a table that hold only the previous week data and the current week data form the main table.

[ranman256]

on a form, have the dates for the current data:
txtStartDate, txtEndDate

and the prev data (these can be hidden if you want):
txtPrevStart, txtPrevEnd

when the current is entered, the afterupdate event can fill in the previous datas

sub txtStartDate_Afterupdate()
  txtPrevStart = DateAdd("d",-6,txtStartDate)
end sub

sub txtEndDate_Afterupdate()
  txtPrevEnd = DateAdd("d",-6,txtEndDate)
end sub

then the query can use these

query qsCurrent:
select * from table where [date] between forms!myForm!txtStartDate and forms!myForm!txtEndDate

query qsPrev:
select * from table where [date] between forms!myForm!txtPrevStart and forms!myForm!txtPrevEnd

then you can put both queries together in a union query.