access calculating machine

[problem]

I want to make a calculating machine.

IF i have a score, i want this value become a string

e.g.
if [num]>80 and <100 = "A"
if [num]>70 and <79 = "B"
..
..
..
how to make the string out ?

 

[Jeff Boyce]

One approach would be to write a function that accepts a numeric input and
returns a character output. You could use a series of If... Then statements
or a Select Case ... statement in the function.

Just one person's opinion...

Jeff Boyce
<Access MVP>

 

[problem]

in excel, i can do it easily~
but in Acces, i can't do anything.....coz i dun know how to make the code in
the function....

so ....you can help me?
THX !

One approach would be to write a function that accepts a numeric input and
returns a character output. You could use a series of If... Then statements
or a Select Case ... statement in the function.

Just one person's opinion...

Jeff Boyce
<Access MVP>

I want to make a calculating machine.

IF i have a score, i want this value become a string

e.g.
if [num]>80 and <100 = "A"
if [num]>70 and <79 = "B"
.
.
.
how to make the string out ?

 

[Jeff Boyce]

It might "help you" more to spend a little time looking at Access HELP on
the topics of If ... Then and Select Case functions.

The generic approach would be to create a new code module, use one of these
(or other) functions to accomplish what you want, close/compile, then call
the function from whatever you are working on (?perhaps a query?).

If this seems like way too much work, is there a reason you don't just use
what you already know how to do ... carry this out in Excel?

--
Good luck

Jeff Boyce
<Access MVP>

in excel, i can do it easily~
but in Acces, i can't do anything.....coz i dun know how to make the code in
the function....

so ....you can help me?
THX !

One approach would be to write a function that accepts a numeric input and
returns a character output. You could use a series of If... Then statements
or a Select Case ... statement in the function.

Just one person's opinion...

Jeff Boyce
<Access MVP>

I want to make a calculating machine.

IF i have a score, i want this value become a string

e.g.
if [num]>80 and <100 = "A"
if [num]>70 and <79 = "B"
.
.
.
how to make the string out ?

 

[Jamie Collins]

One approach would be to write a function that accepts a numeric input and
returns a character output. You could use a series of If... Then statements
or a Select Case ... statement in the function.

This could be done in SQL code using the ready-rolled SWITCH function e.g.

SELECT SWITCH(
MyIntCol>=80 AND MyIntCol<100, 'A',
MyIntCol>=70 AND MyIntCol<80, 'B'
) AS my_text
FROM MyTable

Jamie.

--