Recent content by DSCartwright

That has worked perfectly. thank you very much

Not meaning to sound stupid but where should i put the IF statement?

or would i be better using an SQL statement?

Okay i will try explain a little better. When records are like this no action needs to be taken because the surname (required field) has been occupied. ID Full Name Forename Surname Salutation 1 John Smith John Smith Mr When there is a salutation but no...

Sorry about formatting i don't know how to get it right

ID Full Name Forename Surname Salutation 1 John Smith John Smith Mr 2 Colin Smith Mr Colin Smith 3 Carl Berry This is how it is currently set up, where possible i want to pull the salutation into the surname but when...

Hi Guys, I have a table that has these fields. Full Name, Forename, Surname, Salutation. This data has been extracted from another database where the Surname field was not required but it is now. So i need to find a way to pull data from the salutation field into the surname field where...

You're a good man my friend. Thank you very much.

I understand your concern but this is being move from one existing system into another existing system and the way data is stored is very different and there will be no need for individual address lines once done.

This will be a one off move, the data has been refined from an existing database i want to move this information permanently from one database to another but moving it into new fields. The join is required as this will also be permanent as the address is just one field in the new database. Regards

Hi, thanks for looking at my query. I want to be able to copy the data within a selected field and then place it into a fresh database is this easily done? my second questions is i have several fields which need to be merged into one 'Address' field as currently i have data with Building Name...

Ok I have eliminated the problem i was having above, I had double posted something in to the SQL statement by accident. however now when i try to execute my query i am getting this error. Syntax Error (Missing Operator) in expression. 3077 This is my code Set MySet =...

Okay, I decided that there was no need to use parameters as another query finds what i need to cover parameters, however through removing that my SQL statement is carrying another error which is "JOIN expression not supported. 3296. This is my code. Set MySet = MyDb.OpenRecordset("SELECT...

also if there was an alternative to this method i would be open to try it, regards

Hi, Basically I want to use the record set query to highlight and bypass any records which don't contain any data, I initially tried to do this but it did not like the queries which where set up in the form. What I am unsure of is how to embed my SQL query into the the recordset function as it...