T tessy Guest Aug 11, 2001 #1 situation, multiply cost of item with the amount of items on hand for a total on hand cost. which colums to enter criteria in, do I need to set a parameter?
situation, multiply cost of item with the amount of items on hand for a total on hand cost. which colums to enter criteria in, do I need to set a parameter?
J Jack Cowley Registered User. Local time Today, 20:00 Joined Aug 7, 2000 Messages 2,639 Aug 11, 2001 #2 I assume you are talking about doing this in a query. If that is true then in the last empty column in your query put this in the top field: Total On Hand Cost: [Cost]*[ItemsOnHand] Change Cost and ItemsOnHand for the actual names of your fields.
I assume you are talking about doing this in a query. If that is true then in the last empty column in your query put this in the top field: Total On Hand Cost: [Cost]*[ItemsOnHand] Change Cost and ItemsOnHand for the actual names of your fields.
