How to setup Access to variable inputs and calculate an output?

[Guest]

I am trying to create database that allows a user to input different criteria
and receive a calculated answer. Is this possible?

 

[Norman Yuan]

It is impossible to give you a meaningfull answer other than very generic
answer of YES. You see, the Calculator
(Start->Programs->Accessories->Calculator) can do what you exactly asked:
input different kind numbers, you get calculated result. Someone can program
a calculator in Access doing just that. So, you'd better give more details
on what exactly you want to ask and why aks it in MS Access NG.

 

[Guest]

Yes. Use the following as criteria for specific input --
[Enter criteria]

For non-specific or partial entry use the following --
Like [Enter start of the criteria] &"*"
This lets them enter the first characters of the criteria.

Or --
Like "*" & [Enter start of the criteria] &"*"
This lets them enter some of the characters of the criteria which could be
from the middle.