Search results

Yes I did assign it. I tried it as a new field in a query as well as an update query. got the same message with both. When I used Windows 8 I did not encounter this problem. It's only since I upgraded to 8.1 that this occurred.

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...

tblStats26_TopCostingand Compl_01CMDESCOther Complication Other Complication This is the field. After "Other Complication" there are about 80 spaces I want to trim of. When I use: Compl: Left([CMDESC],InStr(1,[CMDESC]," ")-1) it only returns "Other" in stead of "Other Complication" I don't know...

Tx but I need it to return "Other Complication"

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.