Question i need help from you please

[ga3la]

hi everyone i have project to do, but really i'm very confiose for much things i must to do. for that i come here to ask for help if anyone have little time and be patient

well let me talk about the i mportant:

i do the basic things, and left the complicate things for search and learn and help from you.

what i'm looking for:

i have database wih customers, there are two tables one loyal customers and other free customers, everything i need just applicate of loyal customers.

1- i need make search form by date : just give start date and end date and apear down in table the results
2- i need like warning every 6 mounths show message box warning there is some customer make 6 mounths and need make notes. in same time the warning stay active because maybe i wasn't able to check the program in the same day that have some customer already make 6 mounths, desapear till i make notes and in same time already start counting for next warning 6 mounths.
3- search for customer report to printing

P.S : if you see the loyal customers, there are some customers have two contrat or more just for same customer


thank you so much for by attention and try help, really i need finish that in small period

 

[ga3la]

sorry i forget upload the file

the link is here:

http://www.mediafire.com/?ngjqoumjzxm

 

[Galaxiom]

Firstly combine the two customer tables and include a checkbox field for Loyal.
I suspect you have a lot of normalization to do but I haven't looked at your file.

Please attatch the file to your original post by using the Advance editor page. Then you can delete the second post with the link to that site.

 

[ga3la]

sorry i can upload the file because it's very big, so give me you email and i'll send it for you please

thank you so much