Access 2010: Query to concatenate fields with a space
I have a query to concatenate 3 fields "First Initial" + "Middle Initial" + "Last Name". Sometimes there is no middle initial but I need a space to be in its place but it just joins the “First Initial” + the “Last Name” together. Any suggestions?
It’s our mission to create a product that solves the huge challenges you face at work every day. In case you missed it, here are 7 delightful things we've added recently to monday to make it even more awesome.