B
babyatx13 via AccessMonster.com
I have an inventory table that shows all inventory and units in stock
Inventory Item Text Key
Units in stock Number
______________________________________________________________
(in form view)
I have a form that uses a table that keeps track of the date inventory was
Received
Inventory Number AutoNumber Key
Date Received Date/time
(in datasheet view)
I have a subform that uses a table that keeps track of the
inventory that was Received for that day
Transaction Number AutoNumber Key
Inventory Item Text
auto lookup from Inventory table
Quantity Received Number
Inventory Number
______________________________________________________________________________
(in form view)
I have a form that uses a table that keeps track of the date inventory was
Used
Inventory Number AutoNumber Key
Date Used Date/time
(in datasheet view)
I have a subform that uses a table that keeps track of the
inventory that was Used for that day
Transaction Number AutoNumber Key
Inventory Item Text
auto lookup from Inventory table
Quantity Used Number
Inventory Number
___________________________________________________________________________________
I split the tables up to avoid confusion when viewing information that was
previously entered in the different forms.
When inventory is entered in the Received or Used subforms the quantity in
the Inventory table is automatically adjusted.
Inventory transactions are not always entered every day, as they should be,
Therefore I need the report to show the latest date on record,
Inventory as of Month dd, yyyy
_______________________
Item ……… Units in stock.
How do I go about doing this without having the customer type in a parameter?
Since they may not even know the date without looking it up.
Thanks
K Board
Inventory Item Text Key
Units in stock Number
______________________________________________________________
(in form view)
I have a form that uses a table that keeps track of the date inventory was
Received
Inventory Number AutoNumber Key
Date Received Date/time
(in datasheet view)
I have a subform that uses a table that keeps track of the
inventory that was Received for that day
Transaction Number AutoNumber Key
Inventory Item Text
auto lookup from Inventory table
Quantity Received Number
Inventory Number
______________________________________________________________________________
(in form view)
I have a form that uses a table that keeps track of the date inventory was
Used
Inventory Number AutoNumber Key
Date Used Date/time
(in datasheet view)
I have a subform that uses a table that keeps track of the
inventory that was Used for that day
Transaction Number AutoNumber Key
Inventory Item Text
auto lookup from Inventory table
Quantity Used Number
Inventory Number
___________________________________________________________________________________
I split the tables up to avoid confusion when viewing information that was
previously entered in the different forms.
When inventory is entered in the Received or Used subforms the quantity in
the Inventory table is automatically adjusted.
Inventory transactions are not always entered every day, as they should be,
Therefore I need the report to show the latest date on record,
Inventory as of Month dd, yyyy
_______________________
Item ……… Units in stock.
How do I go about doing this without having the customer type in a parameter?
Since they may not even know the date without looking it up.
Thanks
K Board