Calculating from a text field - repost

  • Thread starter GraemeCarpenter
  • Start date
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top