Use ranges (in increments) to enter numbers into a table without .

G

Guest

My goal is to prompt users to enter in their Beacon (credit) score and BNI
Score and Access will query the table and generate the correct interest rate.
But I'm having trouble with the large range of numbers. I need a column for
the Beacon score with a possibility between 800 -600 points and a row for BNI
score between 600-200 points in order to calculate an interest rate. With the
many variables and possible combinations, Is there a way to enter ranges of
numbers in the columns instead of having to enter in each individual possible
combination to generate the correct interest rate in the matrix?
 

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

Similar Threads

Returning a tier and rate 1
saving data from a single form to different table 1
Access Macro Repeat Expression using value of a field in table 0
HOW TO ENTER RANGES OF DATA INTO A TABLE IN ACCESS 2
Can I use Dynamic Ranges to automate complex calculations? 5
Problem with (complicated) expression in query 3
Table relationships - hoping to just enter ID once in form 3
Macro to select a cell in a table from a reference in a different 1

Top