Recent content by Lucy02

Thanks that's great don't know why i didn't think of that in the first place?!!

Matt, the table is as follows: caller id, company called, date of call, result, followup call date So ideally if caller id 1 calls "Mum" on 1/12/06 and her followup call date is 02/12/06 then there should be another call entered into the table on the 2/12/06 from caller id 1 to "Mum" which...

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, thanks for this. What should this be set to or how do i set this? Sorry i'm still quite newbieish! Thanks Lucy

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 Dave, Thanks for this i have had a go at doing this but i'm having problems. At the moment the forms show an enquiry summary for companies and then the subform shows a summary of the contact i have made with the matching companies. However when i try to create the same in the report the...

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

well the reports are entered into a table so the query is from a table. But the ID contains BOTH the employees intials and the date of the report?

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 Jon the dates entered for the telemarketing are in the format of 05/01/06. as in the 5th January 2006. Will this make a difference again as i am still getting no results?! I think i am definitly doing something wrong!

Of course that was completely stupid of me but I have now entered the correct dates and I get no results back which is not true. Does it make any difference that some telemarketing does not have a date for which it was done? Many thanks!

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...