19 items | 2 visits
netjmt t's List: Access 2007
-
-
-
To join text, you use the ampersand (&) operator. For example, here’s how to create a FullName field that draws information from the FirstName and LastName fields:
FullName: [FirstName] & [LastName]
This expression looks reasonable enough, but it’s actually got a flaw. Since you haven’t added any spaces, the first and last name end up crammed together, like this: BenJenks. A better approach is to join together three pieces of text: the first name, a space, and the last name. Here’s the revised expression:
FullName: [FirstName] & ” ” & [LastName]
This produces values like Ben Jenks. You can also swap the order and add a comma, if you prefer to have the last name first (like Jenks, Ben) for better sorting:
FullName: [LastName] & “, ” & [FirstName]
-
-
Oct 06, 09
Este ejemplo me hizo entender de una vez por todas, cómo mostrar un cálculo en un formulario usando datos de la misma tabla sin hacer consultas!
-
Oct 07, 09
Excelentes apuntes antes de comenzar a diseñar una base de datos en Access.
-
Oct 07, 09
Notas importantes sobre la Bases Relacionales.
-
-
-
-
-
-
Oct 07, 09
Importante para entender más Access
-
-
-
Oct 23, 09
Campos predeterminados: Funciones para Date ()
-
1 - 19 of 19
20 items/page
List Comments
(0)
List Info