Exclude Values from a SELECT statement

[Nadine via AccessMonster.com]

Hi!

I have a form which is used to calculate monthly interest. The top part of
the form allows the user to enter Clients that are to be excluded from the
Monthly Interest Calculation. The lower portion of the form is where the
user enters the details for the interest calculation. I will try to display
the design to you.

TOP PORTION OF FORM:
Client to be excluded from Interest Calculation:
** Then I have 8 textboxes displayed for the user to input data.

BOTTOM PORTION OF THE FORM:
Interest Calculation
Plan: ** The user selects the PLAN to calculate the interest (drop
down field)
Start Date: ** The beginning date for the interest calculation (date
field)
End Date: ** The end date for the interest calculation (date field)
Interest Rate: ** The rate the interest is being calculated on.

The form has a command button - when the user clicks the Calculate Monthly
Interest button.....I need to go out to a table and select those clients
enrolled in the plan selected who have an outstanding balance and calculate
the monthly interest.
Monthly Interest = Balance Owing x (days / 360 ) x Interest Rate

BUT - I am not sure how to take the Clients that the user entered in the top
portion of the form and exclude them from my select statement.

I apologize if I have not explained this well enough. Please let me know if
you need further information! Any help would be great appreciated!

Signed....
Desparate for Knowledge!

 

[Guest]

How are you capturing the clients that you want to exclude? Is it a textbox,
textboxes, memo field? Are they in individual fields or in a combined field
as in "Client1, Client2, Client3, etc".

Depending on how you implement the above you could use a parameter query
that would initiate off a button on the form. The query would have where
clauses for each of your parameters (not in ([Clients]), [Plan], [Start
Date], [End Date], [Interest Rate]) and a Calculated value (Monthly Interest).

I hope this is of some help

MAC