D
David Vollmer
In Excel I have lookup formulas for determining if a city/state combination
is considered in a high drug traffiic area or high financial crimes area. I
also have a lookup formula for determining if a country is considered high
risk from a money laundering or terrorist funding standpoint.
The city/state lookup formula utilizes over 50 sheets (one for each
state/possession) and the formula uses a city cell and a state cell in the
master sheet and goes to the applicable state sheet and looks to see if the
city is listed. If so it returns TRUE.
The country lookup is simpler. I have a list of all of the current high risk
countries and if the country shown in the master sheet is on that list it
returns TRUE.
Now I need to duplicate those lookups in Access. When a city and state have
been entered I need to determine if that combination is on the "list". I need
to do the same thing with countries.
I am able in the workbook to "spell check" the country names and would like
to do that in Access. In Excel I have a list of over 300 countries (including
multiple ways of entering them) and check that list against what the user has
entered to see if it is on the list. It's not foolproof but helpful. If the
country name is not found it allows it to be entered and the high risk lookup
still works.
Your suggestions on how I can accomplish these lookups in Access will be
most appreciated. Unfortunately I am not a programmer and get most of the
code I need from with these discussion groups.
Thank you,
David Vollmer
is considered in a high drug traffiic area or high financial crimes area. I
also have a lookup formula for determining if a country is considered high
risk from a money laundering or terrorist funding standpoint.
The city/state lookup formula utilizes over 50 sheets (one for each
state/possession) and the formula uses a city cell and a state cell in the
master sheet and goes to the applicable state sheet and looks to see if the
city is listed. If so it returns TRUE.
The country lookup is simpler. I have a list of all of the current high risk
countries and if the country shown in the master sheet is on that list it
returns TRUE.
Now I need to duplicate those lookups in Access. When a city and state have
been entered I need to determine if that combination is on the "list". I need
to do the same thing with countries.
I am able in the workbook to "spell check" the country names and would like
to do that in Access. In Excel I have a list of over 300 countries (including
multiple ways of entering them) and check that list against what the user has
entered to see if it is on the list. It's not foolproof but helpful. If the
country name is not found it allows it to be entered and the high risk lookup
still works.
Your suggestions on how I can accomplish these lookups in Access will be
most appreciated. Unfortunately I am not a programmer and get most of the
code I need from with these discussion groups.
Thank you,
David Vollmer