Duplicate search

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

In one of my fields, i have customers names so in the
future i can tracks how many requests came from one
certain customer.Is there a query search that can locate
all customers that have submitted repeat requests during
month or year?
Thanks in advance
 
First, if you are truly typing names into a field, how will you know that
one customer (John Jacob Jingleheimer Schmidt) has called under five
different names?:

John Schmidt
John J. Schmidt
J. J. Schmidt
John J.J. Schmidt
J.J.J. Schmidt

AND been mis-typed twice more?:

Jon Smith
John Schmitt

A less-error prone way to handle this is to create a customer table, with
enough info to help the user identify that the caller must be John Jacob
Jingleheimer Schmidt. Then, instead of re-typing the name, in your "Calls"
table, you'd be storing the row ID from your customer table -- do this via a
form, with a combo box to hold/display the list of customers.

To query your "Calls" table, you can select by customerID, and add a date
range for the CallDate field, both of these in the criterion row in the
query grid.
 
Thanks Jeff,

The DB will track corporations and the reason behind
searching by names information is copied and paste from
actual requests sent in by these major corporations.It was
just an idea that for example...searching for Alcoa or
Coca cola would not create problems since there is an ID
ticket submitted for each request to distinquish one
customer request from another.I just wanted to query
search to see how many time alcoa or coca cola appeared in
the name field for week or month....is there a wildcard
search that look for dup entries from all companies?
 
Access HELP mentions "wildcards" for queries. But when you ask for
"duplicates", the implication is "exact matches". It sounds like you want
to find all records for a given company.

You can build a query that includes a prompt in the criterion field, asking
for (a portion of) the company name to be found in the company name field.
See "parameter query" in Access HELP for more information on this approach.

If you combine these two, you'd end up with something like (your syntax may
vary):

Like * & [Company name includes...] & *

to allow you to search for any rows with the text you enter in response to
the prompt being somewhere in the field you put this criterion under
(company name field, right?). WARNING: if you enter simply the letter "o"
in response to the prompt, you'll get every company name with an "o" in it!

By the way, my earlier post still bears review -- if you are entering and
re-entering the text string with the name, different spellings and typos
will mess up your database. Instead, rely on a Person table (or, in your
case, a Company table) and only store the ID from that table. When you
build your parameterized query (see above), use a join between the calls
table and the company table to search by the company's name.
 
Hello,

Actually i am not to concerned about typos since i have been doing the function for years and i am more concerned about finding duplicates.For example, in the query i want to seach for names that appear more than three times in a month regardless of what the request is...i am seaching for repeat requests from various companys at the same time.Is there a search that perform this overall search for duplicates? Thanks for your time/
 
Joe

Please re-read my responses. There is no "canned" search that does exactly
what you want. You have to write a query.
 
Back
Top