Search results

Works like a charm. Thanks.

Awesome. Thanks. Now I just need a way to deal with the McSmiths and MacSmiths.

Thanks, but how would I go about imbedding that in an SQL query? Thanks, but when I tried that it in a simplified select query, it asked me for a parameter value for vbProperCase and didn't return the corrected format. When I tried it as the Union query, it asked me for the parameter value...

Sorry, I should have been more specific. Is there any way I can do the same thing as a format? If I want the names to be all caps in the source table and on forms, but want it to display as proper case on one report, Is there a way I can set the format of the field on the report to display in...

As the title says. Is it possible to format a field so that the first letter of each word is capitalized, but the rest is not?

Cheers! Guess I need to learn more functions.

I'm building a report that requires me to concatenate several fields plus additional words, etc. But not all of the fields are the same data type. I have the date formatted the way I want it in a date/time field in one table (dd mmmm yyyy), and I want to append that date into a text field in...