Data needed displays on 2 records, needed on one

[jereece]

I have a query based on a linked table associated with an SQL database. The query is looking for the following.

YR
CR_No
UserID
Signature_Type (ASSIGN or DUEDATE)
Signature_Date

I want the query to return all of this data in one record however when I run the query one record shows the UserID with Signature_Type of ASSIGN and the other record shows the Signature_Date with the DUEDATE. How can I merge these records or otherwise show all of this data in one record so it will display properly on a report?

Thanks,
Jim

 

[DCrake]

Is there one record or two records in your SQL database?

 

[jereece]

The query returns 2 records. I don't have access to the database itself, only through linking tables. It appears that a new record is entered into the SQL database when the Due Date is set and another record is entered when someone makes the assignment. So on my report I what to display who the report is assigned to and the due date for that report but I don't know how to do this since the data is on 2 records.