Gustav Brock
Gustav at cactus.dk
Sun Jun 25 14:31:31 CDT 2006
Hi Karen
Try with
Trim([LastName] & (", " + [FirstName]))
No comma if FirstName is Null.
Or do it vice versa if LastName can be Null.
/gustav
>>> karenr7 at oz.net 25-06-2006 20:42:27 >>>
When I use this on an unbound field in a form I get the good old "Extra )
in query expression" bug. I keep forgetting what the fix is.
Trim([LastName] &", "& [FirstName])
This is so dam annoying!
Regards,
Karen Rosenstiel
Seattle WA USA