AnsweredAssumed Answered

create year archive

Question asked by bennyhendrikx on Jan 4, 2012
Latest reply on Jan 4, 2012 by bennyhendrikx


create year archive


The goal is make an Archive for orders by year, 

detail information about records : 

have a table orders  with a date field  (full date)  and a year field (Year ( datum )) works fine 

now i want to place all records in the year 2011 to a new (table or file )  not sure what would will be the best 

on the opening page i have a drop down field  (year)  i want that it only shows data from that year  

wondering what will give the best results, archive yearly or montly , to another file or in the same database,

  (lets say that the buisniss populate about 500 orders each year)