Matching

[Sarn]

Basically I'm trying to make a database that will check for me if
phone numbers is on the do not call list.

I got the numbers i want it to check my database against in 6 table
that have been put together in a Union query. The numbers from the DN
list come in a comma seperated value list. I opened that in excel an
imported the excel sheets into tables in access. Excell can only hav
65,000 something rows tho which is why i have 6 tables ;-/

But i think the union query should be sufficient.

what i want to do is have a value set to registered if a phone numbe
in the customer table matches a number in the union query or have i
say not registered if it doesn't find a match.

I have not idea how to do that though. Any help would be appreciate
;-

 

[Sarn]

oh yeah ;-P I'm using Access 200

 

[Tom Wickerath]

Sam,

In the interest of leaving people, who have registered with the DNC list (myself
included), alone to enjoy their peace & quiet I will attempt to answer your question....

I recommend starting over with your comma separated value (*.CSV) file, and import
directly into Access. It's either this, or use a series of append queries to append the
data together into one table for the DNC list. You want your DNC list to be in one
table--not spread out over six tables. Access does not have the # records limitation that
Excel does. It does have various limits, such as maximum file size of 1 GB (Access 97) or
2 GB for later versions of Access. You can see these specifications by searching Access
Help for "specifications" (without the quotes).

After you get your DNC list into one table, take a look at the Find Unmatched Query
Wizard. This wizard will help you to quickly identify those numbers in your customer's
table that are not matched with a number in your DNC table. You can then easily run an
update query, to update the value of a field in your customer's table to "not registered"
for the recordset returned by this query. Finally, update the balance of the records in
your customer's table (ie. criteria: <> "not registered" ) to registered.

Tom
____________________________________


Basically I'm trying to make a database that will check for me if a
phone numbers is on the do not call list.

I got the numbers i want it to check my database against in 6 tables
that have been put together in a Union query. The numbers from the DNC
list come in a comma seperated value list. I opened that in excel and
imported the excel sheets into tables in access. Excell can only have
65,000 something rows tho which is why i have 6 tables ;-/

But i think the union query should be sufficient.

what i want to do is have a value set to registered if a phone number
in the customer table matches a number in the union query or have it
say not registered if it doesn't find a match.

I have not idea how to do that though. Any help would be appreciated
;-D