Add Fields to the Query

3. Try it: Add Fields to the Query

From tblReceipt select the following Fields:

ReceiptID

CustomerID

DateRented

 

From CustomerNameSQ select these Fields:

FullName

CityStateZip

HomePhone

 

Do This, Now: Save the Query

Go to File->Save.

Enter a name: ReceiptSQ.

Click OK.

 

Close the Query. The Record Source for the Receipt Form is done.

Exam 77-885: Microsoft Access 2010

4. Creating and Managing Queries

4.3. Manipulate fields: Add Fields to a Query

Query Tools ->Design->Query Type->Select