Search results

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

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, 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:

Hello, Can someone help! I have a table where the referance numbers are as follows; CCB0012008 CCB0022008 CCB0032008 and so on. What I would like to do is when a new entry is entered in the form the referance number is automatically incrimented by 1 and shown on the form for the new...

Can anyone help me, please! I work for a charity and I am trying to find out how many people have donated within 1, 2, 3 and 4 months, from the start of the appeal date. the appeal date field is [CAPPDATE_S] the record of payment field is [CRECDATE] Can anyone tell me how to create a...