Can I use input from the user in a calculation?

[Guest]

--
Ruth

 

['69 Camaro]

Yes. But without knowing how you expect to get this input from the user and
where this calculation needs to be computed, we can only give you some vague
suggestions on how to do this. For example, if the user types 4 into the
txtHours text box and types 20 into the txtRate text box, then the following
calculation can be made in a VBA procedure:

total = Me!txtHours.Value * Me!txtRate.Value

.... and 80 will be stored in the variable named "total."

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)

 

[Guest]

I want the user to input leadtime and safety margin so that I can multiply
the sum by the daily demand. This should give me the # of pieces needed in my
kanban.
I'm thinking of computing this in a query. Do you know a better way?

 

['69 Camaro]

Hi, Ruth.

I'm thinking of computing this in a query.

If the query is gathering the information from all of the necessary tables
to compute the daily demand, then computing the total # of pieces needed in
a query is quite adequate.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)