Search results

Good day, I'm having trouble converting text to proper text in Access 2010 using Windows 8.1 as OS. The message I keep getting is: The expression you entered contains invalid syntax You omitted an operand or operator, you entered an invalid character or comma, or you entered text without...

Hi I need to trim text with a space between two words but then only the first part is returned e.g Field Name: CMDESC - Text "Other Complication" When I use: Compl: Left([CMDESC],InStr(1,[CMDESC]," ")-1) it only returns "Other" How do I get it to return "Other Complication":confused:

I've set up a query to concatenate fields: Name_ID:[compl01]&","&[Compl02]&","&[Compl03] But this returns as each field in a separate row in stead of in one field. Also how do I exclude fields with no value in it.? What is the maximum number of fields that can be concatenated?

My name is Joan. I'm a RN working in the managed health care environment. I taught myself how to use Access and have developed a few programs to do statistics for the company. My knowledge of Access is basic.