Search results

Hi there, I have created a table to show client addresses. The table shows client name, address 1, address 2, address 3 and postcode. I need to pull a query to show all clients which don't have ANY of the address fields completed AND another query to show all those that have something completed...

Hi there, I have a table which shows telemarketing that has been completed on a weekly basis where the caller places the date they called in one field and a followup date (if needed) into another field if a followup call needs to take place. I want to create a query which will show me all...

Hi, I have created a report showing company names and telephone numbers which i need to export into a word document. However, when i export the report some of the telephone numbers disappear and all i am left with is the area code and yet you can see the telephone numbers clearly in the report...

Hi, I have created a report which shows enquiries made by different companies. Some companies have made 3 different enquiries which the report shows. I have also entered a sub report into this report which shows a summary of the contact that has been made by myself to the matching companies...

Hi there, I am trying to save my form that i have created as a report by right clicking on the form and choosing save as report. However, my form includes a subform but the subform does not show up in the report. Any ideas as to why this and how it can be shown???? Thanks in advance Lucy

Hi Guys I have reports that I complete for 2 employees. I always give the reports an id to show who the employee is and the date of the report e.g LK 13/02/2006 CR 13/02/2006 How would I create a query so that i could say show me all of the reports for employee LK between the dates of...

Hi All This is pretty urgent so your help would be greatly appreciated! I need to do a query where i can find companies who were telemarketed between the dates of 01/01/2006 and 31/02/2006. When i type this in the criteria box however, it fails to do anything. PLEASE HELP!!! Many thanks

Hi all I have a form which lists the name of companies and the contact people within each company. If i want to find the company "Watchdog" for example i have to go through all the records on the form until i find it. I was wondering if there is a way i can produce tabs on the form lettered...

Hi all I have a form which lists the name of companies and the contact people within each company. If i want to find the company "Watchdog" for example i have to go through all the records on the form until i find it. I was wondering if there is a way i can produce tabs on the form letter A-Z...

Hi Guys I'm sure someone has asked this before but I have been searching for ages and cannot find an answer. I have a table which i enter all appointments that have been made to which companies. So that i don't have to enter the company name in full each time they get an appointment I thought...

Hi i'm not really sure what i'm meant to be doing. In a previous query post I was told that I would need to use a VBA code to update a temporary table as two tables that I wanted to link together are not in a one-to- many relationship. Can anyone give me any help as to how I do this? I am a...

Hi guys I was wondering if anyone would be able to help me? I have two tables which can be linked together as they both contain a field called Company Name. However, in one of the tables I want Company Name to become my primary key but this field contains duplicates. How can Isolve this so that...

Hi Guys I have two tables appointments and telemarketing. I want to be able to view all companies which have had appointments AND telemarking. However when i have previously tried to do this if more appointments have been made to say the company called *lucy* than there has telemarketing the...

Hi Please can some help me asap. I need to do a querie which joins two tables together. I have a telemarketing table and an appointment table. The idea is that when an appointment is made telemarketing should be done afterwards to the same company. Therefore I want to view all of the...

Hi Please can some help me asap. I need to do a querie which joins two tables together. I have a telemarketing table and an appointment table. The idea is that when an appointment is made telemarketing should be done afterwards to the same company. Therefore I want to view all of the...