Recent content by Robin Hood

Hi, DatePart("m",[CAPPDATE_S]) Is linking the date under the correct month. eg 12/12/12 would come under Dec. cheers Serge

Thanks Paul, Here it is. SELECT [Agents ID].Name, Count(Collect.CAPPEAL) AS CountOfCAPPEAL, DatePart("m",[CAPPDATE_S]) AS expr4, [Agents ID].[Agent ID] FROM Collect INNER JOIN [Agents ID] ON Collect.AgentId = [Agents ID].[Agent ID] WHERE (((Collect.ccolamt) Is Not Null And...

Hi thanks for your replies, how do i copy and post my query to the forum? Serge

Hi I wonder if anyone can help. I have made a query to count the payment field criteria stating "is not null and >0" So that I know the number of payments made for each sales person on the phone. Unfortunately the query picks up the fields that have 0 in them as a payment and counts them to...

Hello DCrake, Thanks for your reply. The text file is not adding any new appeal/reference numbers. What it has is the original appeal/reference numbers ,names, addresses ect. But what needs to be updated in the database is the type of payment, amount and date. At this moment in time in the...

Hello Dennisk, Thanks for your reply. The data in the table does not use primary key as they have unique appeal and reference numbers ie; 1202/0123 is that going to make a difference? cheers Robin

Can anyone tell me how I can update or append the data in a table with data in the form of a txt file? The data in the text file is not new data to go into the table. Its updating existing data in the table, by entering information such as: Payment, type of payment, amount and date of payment...

Hello, I have managed make a table of approx 150,000 duplicate telephone numbers which have donated to the charity I work for over a number of years. Some have donated 2,3,4 or 5 times over the years. Is there a way to find out how many people have actually donated more than once. Also to...

Hello Gemma, Thanks for your reply. I did initially put DoCmd.RunSQL "Delete * From [Cardboard Letters]" But when that did not work I tried changing to DoCmd.RunQuery "Delete * From [Cardboard Letters]". Sorry DCrake for the wrong info. But with both I got the same result - "Microsoft Assess...

This is what is on the OnClick event of my command button. DoCmd.RunQuery "Delete * From [Cardboard Letters]"

Hello DCrake, Sorry for the lateness of my reply, I have been away. I have tried to do as you mentioned in the On Click of the properties of the command button on my form. But it comes up with "Microsoft Assess can't find the macro 'DoCmd'. I have made a delete query that works, but I...

Hello, Is it possible to create a query, that will delete all the data in a table. I would like to do this so that I can create a command button on a form that will clear that table of data. Many thanks Robin :cool:

Rabbie, Many thanks for that. Its just what I needed. I will study and learn from it. Once again, Thank you Robin

Hello Rabbie, Unfortunately I have got myself tied up in knots. I am not as clever as I thought. I have created 2 new fields in my table called 'Seqno' and 'Year next to the field called 'Reference Number'. In the 'Reference Number' field in design view I have set the 'default value' to...

Hello Rabbie, Thanks for you quick reply. This is all new to me and I have no training in this field. I will try and work around what you have said, but it may take me a while as I am a complete novice. I will let you know how I got on. many thanks Robin