|
There are
several common Query errors. Each mistake has it a different error
message. The following pages will look at two Query mistakes:
punctuation and spelling. 1. Try
This: Create a Sample Query
Go to Create
->Queries-> Query Design. Select a
Table: tblCustomers Click
Add. Click Close Try it:
Add Fields to the
Query Go to
tblCustomer. Double
click to select the following Fields: CustomerID FirstName LastName
Try it: Concatenate Two Name Fields
Place your cursor in Column 4.
Type: FullName:[FirstName]&" "&[LastName]
[FirstName] and [LastName] are
Fields from tblCustomer. The two quotes have a space between
them.
Query Design Tools ->Design->Results->Run
Exam 77-885: Microsoft Access 2010
4. Creating and Managing Queries
4.1. Construct queries: Create a
Select Query |
|
| |
