Issue with Finding Customer Calls

[Jorgitopeter]

Greetings from Argentina: I'm pretty new in this, and I need some help from you experts, please!

I have a table in which I take notes about my costumers calls. Each call, have a different date field. I mean:

Peter Johnson

14/07/2007 Called to ask for a pizza

16/08/2007 Called to ask for 12 hamburguers

19/09/2007 Called to ask for the party

I want to find out, for example, how many people called me in August. What do I have to do to specify the find request to make it search into the differents date's fields, of each costumer's record?

I know that if I write 1/8/2007...31/8/2007 in the first date field, then ctrl+n and write again 1/8/2007...31/8/2007 in the 2nd date field then ctrl+n, and then again into the 3rd date field and so on until the 14th date field, I'll get the people who called me in August... But, what do I have to do to make it automatically, by pushing a simple button, and then writting only once "1/8/2007...31/8/2007" in the first date field, to search in all date fields

Well, many thanks for evertything. I'll be so pleased to read your answers. Thanks again.

Jorge

Edited November 28, 2007 by Guest
Topic name lost... best guess

[Lee Smith]

Why 14 Date Fields?

[Jorgitopeter]

Because I use one field for each call from my costumers... I mean, each costumer has his record, and into it, there are the different calls he made. Do you understand me? Thanks for trying to help me.

Jorge

Edited November 27, 2007 by Guest

[AudioFreak]

You'll need a calls table related to the customer using a Customer_ID_Number. Then each call becomes a record in the calls table. That will alow you to search a single Date_Called field for the records you want.

Michael

[Jorgitopeter]

You'll need a calls table related to the customer using a Customer_ID_Number. Then each call becomes a record in the calls table. That will alow you to search a single Date_Called field for the records you want.

Michael

But this is my "calls table", I need another one? Isn't it possible to make a "search" button and specify the search, as pressing CTRL+N?

[AudioFreak]

Do you have a Customers table? I would make one if you do not. Then in the Customers table you could have a portal to enter the calls into the calls table. Hope I'm not losing you I am being vague because I'm at work :

Michael

[AudioFreak]

Jorge,

I just slapped this file together for you to show you what I meant. Hope this gets you going.

Michael

Edit: I actually rushed that too much and didn't realise I left part of it off. Please see the newly attached file

Notes_Portal.zip

Edited November 27, 2007 by Guest

[Jorgitopeter]

Thanks a lot... but I'm pretty lost... Here I slap a copy of my database... Maybe if you see it, you'll find out exactly what I need... Look the "search by month" button... that is what I'd like to modify to search into the calls

I really aprecciate what you are doing... thanks again!!

Jorge

PD: "llamadas realizadas" means "calls"

cct_BIEN3_Unificaci__n.zip

Edited November 27, 2007 by Guest

[Lee Smith]

Another Table, Yes, and maybe more than that, depending on all of the things you might want in your database. It is not unusal for a solution to have many tables, so don't confine yourself to one.

I would recommend that you get a hold of a book or two on Relational Database Design, and subscribe to a videos sites or two (such as

http://www.filemakermagazine.com/

http://www.databasepros.com/training.html

or

http://movielibrary.lynda.com/html/modListing.asp?vid=104 ).

HTH

Lee

p.s.

I was looking for one of the addresses above, and came back to a lot of posts.

[AudioFreak]

Hi Lee,

After the server crashed yesterday Jorge pm'd me and I ended up helping him there through the day. As the server was still kinda intermittent and this thread was gone at the time.

Here is a copy of his file which I modded in case anyone else was reading this and wants to take a look.

Michael

cct_BIEN3_Unificaci__n.zip

Edited November 28, 2007 by Guest

[Jorgitopeter]

Thanks my friend. It's just what I needed. Thanks a lot. Good Luck.

[Jorgitopeter]

Hi again! It's really like AudioFreak sais: "the more you learn, the more you realize there is plenty more to learn."!

I've been testing that script you (audiofreak)give me about searching records in the day, in the week, past week, past month, etc... It's really cool, but I have a little little problem: I created a new layout to show the found records. I've also created a "city zone" field to know from where my costumer is calling me. The thing is: when I search "today's records", the "city zone" it shows me, isn't the one of the today's record, but the cityzone of the first record of that costumer (I mean, not today's cityzone, but e.g. yesterday cityzone, when my customer called for the first time).

I attach my database and a picture to show you what I mean. I guess that if the search is made from the Calls table, it'll be allright, but I don't realize how to change the script to do it.

Well, thanks for all your help and for sharing your knowledges. Thanks a lot.

cct_BIEN3_Unificaci__n_Copy_INGL__S.zip

[Jorgitopeter]

I have just solved my problem... the thing was that I was missing a script's step... Sorry for bother... you're the best! Thanx for the pacient too!!! B)