Search results

Hello. Having issues with a table with Phone Number field, which is programmed to include 0 at the beginning. I am needing to remove the leading zero through a update query, leaving 10 characters instead of 11. This field is a short text field in the table it does have a input mask of...

Ok cool, Thank you. Will try once I get into the office. Really appreciate everyone's help.

Thank you. What if I choose a selection from the combo box field, titled school, selecting Eastern High. How can I have another field, check box, to show automatically a checkmark?

Hello...i have a form that needs to be programmed to fill a yes/no field automatically by a selection made from a combo box of another field. If nothing is chosen, then the yes/no field will remain empty. Would like to put the programming statement in the design view control source in the yes/no...

Thank you...I will look at the code too. But I am not well verse in code, as much as, putting the formula within the query itself. But will still look at it. Appreciate all the help. Will let you all know what happens.

Thank you, I will try when I get in the office. Appreciate the help, immensely!!

Hello, this is QueryStumped from KY. Avid Access user, love it. Not a programmer, but able to create and maintain databases, queries, reports, and macros. Recently stumped on a request, visited several websites/blogs. Need to parse name field. Comes in as LName,FName MI. I need Last Name and...