For this assignment I followed along with the text book to create a query using expressions and build an example. I used expressions to create a new text field by concatenating fields containing text and string constants. The string constant encloses the text in double or single quotation marks. Used the ampersand character (&) between fields to indicate that I want to concatenate them. So the output would look like, for example, Last name, First name, Middle Name (Andrew, David L.) and city, state, and zip code (Bethel, AK 99559). The query accomplished names, cities, states, and zipcodes. Maybe it could be improved by adding telephone or cell phone numbers. I included a screenshot to show the query.
Nice work, thanks for including the screenshot, though you might want to make them larger and put them in your post below or above your text.
ReplyDelete