Recent content by Hoganc

Unfortunatly I cant - the data comes from another system that just pays customers out. which is why it has different details at the end i.e. a persons name smith and a customer number - so smith needs to be removed with all the versions of the customer or transaction number whichever has been...

Hi G Thanks for that but I need to eliminate more than one name at a time hence the table of names but then thier wildcards would come after - it is because the system uses smith then some kind of customer number ?? aftwards and sometimes before.. how can i use the items on a table and then a...

Hi All I have been running a query to find out the name and addresses of some of our customers but some data keeps coming in to the results that i dont want to see. The data is in the Name column so I have built a second table and put the names of the items i do not wish to see in the second...

hi there, thanks for that but could you explain a bit more - understand how to make a left join but how do I remove all the variables in teh list so i want all the smiths removed but i want a smith, D Smith, simon Smith etc removed is there a way to add an * to the query

Thanks Wayne too much appreciated. .. I do have another question for both of you then.... may be should post a new thread. I would like to run a query different one and have the results of the query listed and then ...... remove all the occurances of a name from the query but the names of...

Hi All If anyone can assist with this as the developer who normally fixes these things is off sick and I need this completed.... great I have csv text files on the server called CH200705 and CH200706 which need to be imported without headings to table Payments. I have a form on the startup of...

Hi All If anyone can assist with this as the developer who normally fixes these things is off sick and I need this completed.... great I have csv text files on the server called CH200705 and CH200706 which need to be imported without headings to table Payments. I have a form on the startup of...

Hi all, thank you very much, thats done it... how you worked it out I have no idea but I am very greatful thank you!! :-)

Hi G in a single table there is customer numbers (or policy numbers) - these people can have lots of policies transaction types - 8 transaction types in all - debit, credit, cheque payment etc. and what I am trying to do is find all the customers numbers where they have more than one...

sorry that was supposed to be false data for you to understand the column headings are... policy numbers, movement types, transaction number the number whether the payment goes into company out or through -

Hi Gary thanks for that, much appreciated. Data is Policy/customer number Movement transaction (unique) 11111 in 1 11111 in 2 22222 out 3 33333...

thanks for the help there!

I had a similar problem the other day, I had a table (query results) which i wanted to display and a notes table which i wanted to update as i looked at the items. (i.e. I wanted to click the query results and go to the relevant notes) to do this i created a blank form put a text box in the top...

Policy numbers = Customer number there is also payment numbers = which are transactions which are unique and then address etc details also there is whether the payment is coming into us out from us or through us. During the month you cant have a combination only multiple payments out, through...

Hi all I really could do with some assistance with this it may sound quite simple but for some reason I cant do this?? and its driving me nuts! I have a column name [policy] and a column name [movement type] the rule is you cant have a policy number and different movement types you can have...