I have a database that cosists of many different customers and some of these have called name times and others may have only call.
My question is:
can you run a syntax criteria to pull "ONLY" the caller that called once?
thanks
I have a database that cosists of many different customers and some of these have called name times and others may have only call.
My question is:
can you run a syntax criteria to pull "ONLY" the caller that called once?
thanks
What tables do you have? How are tables related?
You can do what you are asking provided that your data is organized and yyou can identify callers and number of calls.
First I would like to appoligize for the amount of typos in my former post. I didnt prrof my entry like I should have.
So, here is bassically what I have...Lets say:
John Smith calls from (555)243-1342
(555)243-9709
and (555)654-8070
Jerry Lonex calls from (974)601-4845
Peter Noix calls from (646)667-0466
(646)485-0407
As you can see, John and Peter both are repeat callers. Maybe the first time the called from their cell phone, and the next time from their bussiness phone. However, Jerry is a "one-time'caller". These are the ones I would like to capture perhaps in a report....
**hope that was helpful in some way
That's fine. But what tables are in your database?
these are all in a customer table
Customer First Name
Lastr Name
Phone Number
Company Name
Address
etc;
First approach, I can think of
but what if you get many calls from John Smith? What if there are several John Smiths?SELECT [First Name] & [Last name] AS UniqueCombo
FROM YourTableName
GROUP BY [First Name] & [Last name]
HAVING (((Count([First Name] & [Last name]))=1));
Last edited by orange; 08-28-2011 at 12:30 PM.
ORANGE<<< I see what you have sent to me. Now how would this make the final results look like? I think I undersatrand a bit on which way you are having mne to go here. Could you be just a bit more in detailed..... I think I am beginning to understand you....
thanks a million !!!!!
** Oh and to answ2er your question, Yes I will have name calls from john and several different numbers, but i need to able to pick his name out of a search when he calls. thats why I am trying to come up with sort of plan...