hello i have a query where im trying to create reorder level the most basic one if possible
i have a an item table with field name QuantityinHand i just also added another field and named it reorderlevel
and i have also created another new table called "T Reorder" with 2 fields an Auto ID and a "ReorderYesno" Field which has 2 rows, yes and no
i need to write a code which looks similar to the indicated below
Reorder: IIf([QuantityinHand]<[reorderLevel] then ([reorder].[ReorderYesno]="yes",else [ReorderYesno]="no"
i will create a report out of the T Reorder, and set a query as a sub report below, and set master child field to yes, and all the ones which have yes will show up, and we got ourselves a reorder report based on whatever is less then the reorderlevel