|
Do This:
Confirm the JOIN CustomerID
from tblMovieRented CustomerID
in tblCustomers. 9. Try
This: Add Fields to the Query Add the
following Fields to the QBE Grid: FullName: [FirstName]&" "& [LastName] Address1 CityStateZip: [City] & " " &
[State] & " " & [Zip]
Now, Try This: Run the Query Go to Query Tools ->Design->Results->Run. What Do
You See? The rptOverdueSQ Query includes
the name and address. Save
and Save, again. Close
the Query.
Exam 77-885: Microsoft Access 2010
4. Creating and Managing Queries
4.3. Manipulate fields: Add Fields
Query Tools ->Design->Results->Run |
|
| |
