type mismatch in expression

[lilg1924]

Hi, I am an access newbie. I've downloaded a dummy mdb from a forum.
Problems: an error pops out that " type mismatch in expression" when I use "qryDocumentListing“, ”qryLastest DocRevList“, and ”rptDocmentRegister“, can anybody help? thanks.

[ConneXionLost]

Open the query [qryLatest DocRevList] in design view.

Delete the join:

tblDocRevisionsLog.actionee = tblUsers.userID

Make a join:

tblDocRevisionsLog.actionee = tblUsers.firstname

Cheers,

[lilg1924]

Open the query [qryLatest DocRevList] in design view.

Delete the join:

tblDocRevisionsLog.actionee = tblUsers.userID

Make a join:

tblDocRevisionsLog.actionee = tblUsers.firstname

Cheers,

problem solved, THANK YOU SIR!!

[lilg1924]

Open the query [qryLatest DocRevList] in design view.

Delete the join:

tblDocRevisionsLog.actionee = tblUsers.userID

Make a join:

tblDocRevisionsLog.actionee = tblUsers.firstname

Cheers,

Hi there, I have a new problem, the reports in the access(rptDocumentRegister, rptChangeReqDetailed, rptChangeReqSummary) turn out nothing. Can you fix them for me?
Appreciate.