N
nastravia79
Guest
Hi
i was hoping someone can help me with this, i am using access 97, i have a table from which i am trying to generate a query , basically what i want to do is for the query to show stock that is less than or equal to a percentage of a field called prefered stock, for example, if say my prefered stock level is say 200 units, when i run the query i want it to show all products whose stock levels are less than or equal to 40 percent of the prefered level, enabling me to see what needs to be ordered , however i do not know what criteria to add into the query to do this or how its done , say my field name is prefered_level and i want to show all products that are 40% of prefered level do you knwo how i would phrase this in the criteria or can access handle such a calcualtion, any help is much appreciated
thanks
j
i was hoping someone can help me with this, i am using access 97, i have a table from which i am trying to generate a query , basically what i want to do is for the query to show stock that is less than or equal to a percentage of a field called prefered stock, for example, if say my prefered stock level is say 200 units, when i run the query i want it to show all products whose stock levels are less than or equal to 40 percent of the prefered level, enabling me to see what needs to be ordered , however i do not know what criteria to add into the query to do this or how its done , say my field name is prefered_level and i want to show all products that are 40% of prefered level do you knwo how i would phrase this in the criteria or can access handle such a calcualtion, any help is much appreciated
thanks
j
