Recent content by JaniceKL

Hello - I have not reposted the code with the [] because it still did not work. Apart from either of the two following codes, can you advise how I can fix this problem please. 1) SELECT FirstName, STRCONV([FirstName],3) as FirstName_in_Proper_Case FROM DVAClientListTable 2) SELECT FirstName...

Thank you again CJ - but I have used the [] but still receive an error.

Thank you for taking the time to help. I understand, but not understand (if that makes sense) to what you are saying. How do I check and then fix the problem please.

Thank you so much - I had previously used the ([fieldname]), and just retired, but I still get errors. Thank you very much - I have tried with and without the {} - always get an error. I am at a total loss, and it is bugging me to no end. Maybe I need to debug my brain and start again. lol

Thank you for responding - much appreciated. If what you say is happening, how do I fix it please?

Hello - I am also a novice with coding. I have copied and pasted all of the above, and other similar codes, but I receive the following message. Any help would be great please.

Thank you CJ. It was a copy/paste and then I altered the field and tables names, which I have checked numerous times. However, I will start from scratch and redo the copy/paste. Once again, thank you for your very prompt response. Kind regards. Janice

Hello. I have typed in a Query: SELECT FirstName, STRCONV(FirstName,3) as FirstName_in_Proper_Case FROM DVAClientListTable. FirstName is the field name and DVAClientListTable is the name of the table. Before doing this I researched to discover the correct (or one of) code - I followed...

Hello, My name is Janice and I am from Australia. I have not used Access for close to 20 years.