Hi,
I'am new here and I need help please :
I have a production table listing all production batches (multiple within a day - almost 100 new every day) with the fields : date, report, stock, qtity
I need to create (automatically) a new table gathering ONLY the last 6 months added batches and having a new field with a default value of "received" that I can change later. The updating of this table should be made every time this table is requested/opened.
How can I do that please ?
Thanks a lot
I'am new here and I need help please :
I have a production table listing all production batches (multiple within a day - almost 100 new every day) with the fields : date, report, stock, qtity
I need to create (automatically) a new table gathering ONLY the last 6 months added batches and having a new field with a default value of "received" that I can change later. The updating of this table should be made every time this table is requested/opened.
How can I do that please ?
Thanks a lot