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.
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.
Open the query [qryLatest DocRevList] in design view.
Delete the join:
Make a join:Code:tblDocRevisionsLog.actionee = tblUsers.userID
Cheers,Code:tblDocRevisionsLog.actionee = tblUsers.firstname
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.