Quiery field

[yantan2006]

good day to all

I have noticed a strange command and very confused what it the purpose of it. while selecting field from the table. on the first field all the field from the table is selected. on next field there is this command line:

Searchable: [LastName] & " " & [FirstName] & " " & [Company] & " " & [EmailAddress] & " " & [JobTitle] & " " & [BusinessPhone] & " " & [MobilePhone] & " " & [FaxNumber] & " " & [Address] & " " & [City] & " " & [StateProvince] & " " & [ZIPPostal] & " " & [CountryRegion] & " " & [ZIPPostal] & " " & [WebPage] & " " & [Notes] & " " & [CustomerName] & " " & [FileAs]

if you see starting string. there is word "searchable:" and then coloum/field.

what is the purpose of writing this searchable before all the fields and what it does?

on the next (3rd ) field this is the command

CustomerName: Company

does this changes the company name from lastname and first name to company field?

thank you very much for your assistance

 

[xenou]

Searchable and CustomerName are aliases or alternate names. In Access Query by Design, you create aliases by writing the alias and then a colon and then the field, fields, or expression that will define the alias.

We do this in SQL a lot (with a different syntax, if you are writing raw SQL):
SELECT FirstName & " " & LastName as CustomerName

The above standard SQL query would concatenate FirstName and LastName into a single value and call it CustomerName


The big long value called Searchable is just a huge concatenation of a lot of fields. It's probably not the best solution, but apparently someone wants to use it to create a kind of key to search on.

 

[yantan2006]

Thank you very much