Hi,
I'm developing an wharehouse - inventory access database. I have an inventory table (articles, wharehouse, production date, expiring date, Qty ), an incoming and an outgoing table. The articles leave the wharehouse based on the fifo system.
My products have an production date and an expiring date. My outgoing products most first be substracted from the oldest date.
Now I have trouble with my append query. Does anyone have a code to make it work.
Jud
I'm developing an wharehouse - inventory access database. I have an inventory table (articles, wharehouse, production date, expiring date, Qty ), an incoming and an outgoing table. The articles leave the wharehouse based on the fifo system.
My products have an production date and an expiring date. My outgoing products most first be substracted from the oldest date.
Now I have trouble with my append query. Does anyone have a code to make it work.
Jud