Search results
-
M
Vlook up function for access Is this possible?
I am working on recreating an excel file in access. My excel files uses the Vlook up function to get data from a table for calculations. I am calculating Fruit Solids. =VLOOKUP(BRIXVALUE,'Brix Table'!$A$1:$F$752,6)*QUANTITY (BRIX VALUE references a cell, and quantity references a cell just... -
M
Using one dropdown list box to display a selecting in another dropdown list box
I have a form where I have two drop down list box. The first list box is called Transaction_Type. It contains three values: Created, Allocated and Sold The second list box is called Product_Status. It contains 6 items: Allocated, Produced, Reworked, Shipped, To Be Produced, Unallocated. I have...