Help with query...

[Andrew Meador]

I need to create a querry that needs to have values of two
different columns to be looked up in another table. Ex.

Table: ChangeDetails
Column: Note
Column: PaperStatusID
Column: DigitalStatusID

Table: Status
Column: StatusID
Column: Description

I need a querry that will display the Note, Description from the
Status table (where PaperStatusID = StatusID), and Description from
the Status table (where DigialStatusID = StatusID).

I need this in a single query, but I'm not good at queries yet and
can't figure out how to do this.

Here is sample data to clarify what I need:

Table: ChangeDetails
Note: Parcel Drawn PaperStatusID: 3 DigitalStatusID: 2
Note: Dwelling mark removed PaperStatusID: 2 DigitalStatusID: 1
Note: Dwelling mark added PaperStatusID: 1 DigitalStatusID: 1

Table: Status
StatusID: 1 Description: Done
StatusID: 2 Description: Not Done
StatusID: 3 Description: Needs Research

Querry Result:
Parcel Drawn, Needs Research, Not Done
Dwelling mark removed, Not Done, Done
Dwelling mark added, Done, Done

Thanks in advance!