Search results

HA HA Please ignore my last post I have done it hurrah!!! I mis read your instructions. Thankyou soo much for all of your help!!!!!

Hi sorry me again, I have tried your suggestion but everytime I try to run the query or bind the query to a report it tells me that i have mismatched expression? Also there are alot of companies which means that i would need to remember all of the codes for each company. Is there a way of using...

ah you're a star i'm going to give it a go now thankyou so much!!!

Ok i have two tables one called telemarketing and one called appointments. Both tables have fields called Company Name Day Date and Month so each table will show the company which was called or had an appointment and the day, date and month which it took place. What I want to find out is which...

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

vba code??? Hi rv or john. Please could you help me with the vba code??

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 John your reply to my problem was fantastic. The only problem I have now is that some companies had more than 1 telemarketing call so I cannot put the telemarketing company as a primary key as it does not allow duplicates. Is there anyway i can get round this at all? Many thanks for all your...

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

I suppose that is fair enough colin but It just means that people will definatly see my problem and at least try to help me as I am really stuck! U don't have suggestions at all do you?! Please?!!

SELECT [Appointment Commentary].Day AS [Appointment Commentary_Day], [Appointment Commentary].Date AS [Appointment Commentary_Date], [Appointment Commentary].Month AS [Appointment Commentary_Month], [Appointment Commentary].[Company Name] AS [Appointment Commentary_Company Name], Tele.Day AS...

Example: Appt Day, Date, Month Company Name Tele Day, Date, Month Monday 1st Nov *Lucy* Wed 12th Nov Tuesday 2nd Nov *Lucy* Wed 12th Nov Wednesday 3rd Nov *Lucy* Wed 12th Nov So what has happend is there have been 3 appointments made but only 1 telemarketing call has been made. However the...

Example: Appt Day, Date, Month Company Name Tele Day, Date, Month Monday 1st Nov *Lucy* Wed 12th Nov Tuesday 2nd Nov *Lucy* Wed 12th Nov Wednesday 3rd Nov *Lucy* Wed 12th Nov So what has...

Hi Birdy thanks for the tip. Just a quick question how do i do a query within a query??!! Sorry i'm a newbie to all of this access stuff!! Thanks

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