G
GraemeCarpenter
I am presently running a sales database on Approach and i am looking to
convert to Access (which I have little experience of).
I am presently inputting sales data into text fields based on the following
format Y = in stock no sale , X = not in stock no sale, 1 = 1 unit re sale,
(1)
= 1 unit introductory sale , etc as appropriate for no. of unit sales or
introduction (which can be 20+ units)
Within Approach I can calculate the absolute value from these text fields
and the inputs y and x default to zero and I can then drive all calculations
from there in respect of unit sold by person and by team then creating a
search calculation for x I can then derive the no. of non stockist therefore
the number of stockists of each product and derive the stocking levels of
each product and any changes.
In Access if utilise the ABs function then y and x default to #error and no
calculations can be derived.
The basis of the question is how can I maintain the present recording and
input procedure (i.e. using y,x,1,2,(1),(2), i.e one input and recording per
product )and derive calculations -
i.e how do I derive calculations for text fields or any other smart way
around the problem or is this a cardinal sin ?
Regards and Thanks for reading
Graeme Carpetner
convert to Access (which I have little experience of).
I am presently inputting sales data into text fields based on the following
format Y = in stock no sale , X = not in stock no sale, 1 = 1 unit re sale,
(1)
= 1 unit introductory sale , etc as appropriate for no. of unit sales or
introduction (which can be 20+ units)
Within Approach I can calculate the absolute value from these text fields
and the inputs y and x default to zero and I can then drive all calculations
from there in respect of unit sold by person and by team then creating a
search calculation for x I can then derive the no. of non stockist therefore
the number of stockists of each product and derive the stocking levels of
each product and any changes.
In Access if utilise the ABs function then y and x default to #error and no
calculations can be derived.
The basis of the question is how can I maintain the present recording and
input procedure (i.e. using y,x,1,2,(1),(2), i.e one input and recording per
product )and derive calculations -
i.e how do I derive calculations for text fields or any other smart way
around the problem or is this a cardinal sin ?
Regards and Thanks for reading
Graeme Carpetner