Left Join

[Michelle]

I had a query that worked what it did was join two tables so that I con enter
data. However now I had to add more information to the report this caused me
add another table and combine with the other table via a query. Now what I
need to do is join the new query to the other table and I get the correct
info in the query however when I put it into the form I am not able to enter
any information into the form.

OLD Query: works and when used in a form I can enter datat into the tblESS....

SELECT inmtinfo.IN_INMNUM, inmtinfo.IN_NAME, inmtinfo.IN_BLDING,
inmtinfo.IN_SECTION, inmtinfo.IN_CELLDRM, inmtinfo.SEP, tblESSLog.EXERCISE,
tblESSLog.SHOWER, tblESSLog.[YARD #], tblESSLog.RAZOR, tblESSLog.SCREAM,
tblESSLog.MIRROR, tblESSLog.DATE
FROM inmtinfo LEFT JOIN tblESSLog ON inmtinfo.IN_INMNUM = tblESSLog.IN_INMNUM
WHERE (((inmtinfo.IN_BLDING)="H") AND ((inmtinfo.IN_SECTION)=[ENTER POD]));

New Query...when used in form can not enter data into tblESS

SELECT qurCellData.IN_INMNUM, qurCellData.IN_NAME, qurCellData.IN_BLDING,
qurCellData.Section, qurCellData.[Cell#], qurCellData.SEP,
tblESSLog.EXERCISE, tblESSLog.SHOWER, tblESSLog.[YARD #], tblESSLog.RAZOR,
tblESSLog.SCREAM, tblESSLog.MIRROR, tblESSLog.DATE
FROM qurCellData LEFT JOIN tblESSLog ON qurCellData.IN_INMNUM =
tblESSLog.IN_INMNUM
WHERE (((qurCellData.Section)=[ENTER POD]))
ORDER BY qurCellData.[Cell#];

 

[Michel Walsh]

Hi,



seems that your query qurCellData destroys the updateability of the new
query, and I assume that it is probably NOT updateable all by itself, all
alone, so, you cannot update anything implying it too (being more complex
than just the query qurCellData itself).



Vanderghast, Access MVP

 

[Michelle]

I did figure this out... here is the code i used

SELECT tblRHUInmtinfo.IN_INMNUM, tblRHUInmtinfo.IN_NAME,
tblRHUInmtinfo.IN_RACE, tblRHUInmtinfo.IN_SECTION, tblRHUInmtinfo.BSCB,
tblESSLog.SEP, tblESSLog.EXERCISE, tblESSLog.SHOWER, tblESSLog.[YARD #],
tblESSLog.RAZOR, tblESSLog.SCREAM, tblESSLog.MIRROR, tblESSLog.DATE
FROM tblRHUInmtinfo LEFT JOIN tblESSLog ON tblRHUInmtinfo.BSCB =
tblESSLog.BSCB
WHERE (((tblRHUInmtinfo.BSCB) Like "*" & [Enter Pod:] & "*"))
ORDER BY tblRHUInmtinfo.BSCB;

Hi,



seems that your query qurCellData destroys the updateability of the new
query, and I assume that it is probably NOT updateable all by itself, all
alone, so, you cannot update anything implying it too (being more complex
than just the query qurCellData itself).



Vanderghast, Access MVP

I had a query that worked what it did was join two tables so that I con
enter
data. However now I had to add more information to the report this caused
me
add another table and combine with the other table via a query. Now what
I
need to do is join the new query to the other table and I get the correct
info in the query however when I put it into the form I am not able to
enter
any information into the form.

OLD Query: works and when used in a form I can enter datat into the
tblESS....

SELECT inmtinfo.IN_INMNUM, inmtinfo.IN_NAME, inmtinfo.IN_BLDING,
inmtinfo.IN_SECTION, inmtinfo.IN_CELLDRM, inmtinfo.SEP,
tblESSLog.EXERCISE,
tblESSLog.SHOWER, tblESSLog.[YARD #], tblESSLog.RAZOR, tblESSLog.SCREAM,
tblESSLog.MIRROR, tblESSLog.DATE
FROM inmtinfo LEFT JOIN tblESSLog ON inmtinfo.IN_INMNUM =
tblESSLog.IN_INMNUM
WHERE (((inmtinfo.IN_BLDING)="H") AND ((inmtinfo.IN_SECTION)=[ENTER
POD]));

New Query...when used in form can not enter data into tblESS

SELECT qurCellData.IN_INMNUM, qurCellData.IN_NAME, qurCellData.IN_BLDING,
qurCellData.Section, qurCellData.[Cell#], qurCellData.SEP,
tblESSLog.EXERCISE, tblESSLog.SHOWER, tblESSLog.[YARD #], tblESSLog.RAZOR,
tblESSLog.SCREAM, tblESSLog.MIRROR, tblESSLog.DATE
FROM qurCellData LEFT JOIN tblESSLog ON qurCellData.IN_INMNUM =
tblESSLog.IN_INMNUM
WHERE (((qurCellData.Section)=[ENTER POD]))
ORDER BY qurCellData.[Cell#];