Recent content by Ganley

Sorry for the confusion. But what I now need to do is, currently in my table I have some names that are all Upper Case. I just need to keep the first letter as upper case. I’ve created an update query, UPDATE table1 SET [column] = lcase([column]) I am not sure what to do. If I get the...

Any ideas how to Capitalise data in a table.

I have database A & database B, which is a copy of the first. I have made some changes to database B but need to merge one table back into the original database. Any ideas. Thanks.

Thanks for that i'll have a go.

Hello there. I Have a Forename & Surname field. I want to be able to split the the Forename field into Forename & Surname. Any ideas.

Thanks Gemma. You put me on the right track. This is what i ended up doing. Create a new query and bring in the table in question. Drag in both the field or fields that contain the duplicate data and the unique key for that table. Set on the totals for the query by clicking the summation...

Can anyone suggest a way to remove duplicate records. I've come up with this: SELECT *, count(*) cnt FROM tableName GROUP BY fieldname1, fieldname2, .... HAVING cnt > 1 But this does not fully resolve my problem. Thanks.

Thanks Miguel.

Can anyone help me. Attempting to run an update query to strip out some information from a table. Basically I want to remove the Tél : information & leave just the telephone number Tél : (+41 22) 718 10 00 Any ideas. Thanks.