Unable to enter data into left join query

[mlarson]

I have a program that worked fine then they needed to be able to also see the empty cells (inmate cells) on a housing unit when they ran the query. So what I had to do was take two tables and combine them into one with a query.
The two tables are..inmtinfo and tblcelldata...
inmtinfo
IN_INNUM - primary key
IN_NAME
IN_RACE
IN_BLDING
IN_SECTION
IN_CELLDRM
IN_BED
IN_SEP

tblCellData
CellID - primary key
IN_BLDING
IN_SECTION
IN_CELLDRM
IN_BED
IN_SEP

Query that joins the two...
qurCellData

SELECT inmtinfo.IN_INM NUM, inmtinfo.IN_NAM E, inmtinfo.IN_BLD ING, tblCellData.IN_ SECTION, tblCellData.IN_ CELLDRM, tblCellData.IN_ BEDNUM, tblCellData.SEP
FROM inmtinfo RIGHT JOIN tblCellData ON (inmtinfo.IN_BE DNUM = tblCellData.IN_ BEDNUM) AND (inmtinfo.IN_CE LLDRM = tblCellData.IN_ CELLDRM) AND (inmtinfo.IN_SE CTION = tblCellData.IN_ SECTION) AND (inmtinfo.IN_BL DING = tblCellData.IN_ BLDING)
WHERE (((inmtinfo.IN_ BLDING)="H" Or (inmtinfo.IN_BL DING) Is Null))
ORDER BY tblCellData.IN_ SECTION, tblCellData.IN_ CELLDRM, tblCellData.IN_ BEDNUM;

Now what I use to have was this...query that took inmtinfo and joined it with tblESSlog using a left join so I could us this in a form and enter data into the form.
tblESSLog
ESSID - primary key
IN_INMNUM
SEP
EXERCISE
SHOWER
YARD#
RAZOR
SCREAM
MIRROR
DATE

Query that joined the two and qurESSLog (this one works) but does not give the empy cells that they need on the report.

SELECT inmtinfo.IN_INM NUM, inmtinfo.IN_NAM E, inmtinfo.IN_BLD ING, inmtinfo.IN_SEC TION, inmtinfo.IN_CEL LDRM, inmtinfo.SEP, tblESSLog.EXERC ISE, tblESSLog.SHOWE R, tblESSLog.[YARD #], tblESSLog.RAZOR , tblESSLog.SCREA M, tblESSLog.MIRRO R, tblESSLog.DATE
FROM inmtinfo LEFT JOIN tblESSLog ON inmtinfo.IN_INM NUM=tblESSLog.I N_INMNUM
WHERE (((inmtinfo.IN_ BLDING)="H") AND ((inmtinfo.IN_S ECTION)=[ENTER POD]));

So far I have tried to first use the new qurCellData and join it with tbleESSLog I get the correct info but can not enter data into the ESS part of the query.

SELECT qurCellData.IN_ INMNUM, qurCellData.IN_ NAME, qurCellData.IN_ BLDING, qurCellData.Sec tion, qurCellData.[Cell#], qurCellData.SEP , tblESSLog.EXERC ISE, tblESSLog.SHOWE R, tblESSLog.[YARD #], tblESSLog.RAZOR , tblESSLog.SCREA M, tblESSLog.MIRRO R, tblESSLog.DATE
FROM qurCellData LEFT JOIN tblESSLog ON qurCellData.IN_ INMNUM = tblESSLog.IN_IN MNUM
WHERE (((qurCellData. Section)=[ENTER POD]));

When that did not work I tried this use the qurCellData and make a tblRHUCellData with it then use the tblCellData and the tblESSLog and join them.

tblRHUCellData
CellId - Primary Key
IN_INNUM
IN_NAME
IN_RACE
IN_BLDING
IN_SECTION
IN_CELLDRM
IN_BED
IN_SEP

Query that Joins them (get correct data but can not enter information into ESS part)
SELECT tblRHUCellData. IN_INMNUM, tblRHUCellData. IN_NAME, tblRHUCellData. IN_BLDING, tblRHUCellData. IN_SECTION, tblRHUCellData. IN_CELLDRM, tblRHUCellData. SEP, tblESSLog.EXERC ISE, tblESSLog.SHOWE R, tblESSLog.[YARD #], tblESSLog.RAZOR , tblESSLog.SCREA M, tblESSLog.MIRRO R, tblESSLog.DATE
FROM tblRHUCellData LEFT JOIN tblESSLog ON tblRHUCellData. IN_INMNUM = tblESSLog.IN_IN MNUM
WHERE (((tblRHUCellDa ta.IN_SECTION)=[ENTER POD]))
ORDER BY tblRHUCellData. IN_CELLDRM;


Please help I don't know what I did wrong in the second one (why would it work fine for one but not the other)