RE: Make table Query not "updating" 1 field

1. Is there a LastUpdate field in TCURRENT? Double check.

2. Take out the INTO TCURESC part of the SQL. Does TCURRENT show up then?

3. By "not show" do you mean that column is empty or there is no LastUpdate
column created? If empty, your SQL just isn't pulling in anything as you
should have seen in (2) above. If not created, try something like this:
TCURRENT.LastUpdate AS LU

4. Does the SQL have the blank lines like your example shows or is this just
a cut and paste problem? If the blank lines are actually there, remove them.

--
Jerry Whittle
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


"Ralph Wischnewski" wrote:

I created a make-table querry using the standard querry create screen. This
querry takes fields from a few tables and when I run it all fields bar one
appear in the new table. I have no idea why the one field does not show.
The SQL for the querry is shown below.

The field that does not get "updated" is the last "SELECT" field
"TCURRENT.LastUpdate". Does anybody have any ideas?

SELECT

QSelEsc.[Sm Inv Id],
QSelEsc.[Location Id],
QSelEsc.[Contract Amount],
QSelEsc.[Billing Stop],

TESCTYPE.EscTypeID,
TESCTYPE.EscTyprDescription,

TCURRENT.CurrentLabRate,
TLABRATE.Rate,
TCURRENT.CurrentMatInd,
TCURRENT.[Labour%],
[Contract Amount]*[Labour%] AS CurrLabPart,
[Contract Amount]-[CurrLabPart] AS CurrMatPart,
TCURRENT.CurrCPI,
TCURRENT.NotToExceed,
TCURRENT.IndEndDate,
TCURRENT.CPIEndDate,
TCURRENT.NewMatInd,
TCURRENT.NewCPIIndex,
TCURRENT.UpdateStatus,
TCURRENT.ApprovalStatus,
TCURRENT.LastUpdate

INTO TCURESC

FROM TLABRATE, TESCTYPE INNER JOIN (QSelEsc INNER JOIN TCURRENT ON
QSelEsc.[Sm Inv Id] = TCURRENT.SMInvID) ON TESCTYPE.EscTypeID =
TCURRENT.EscTypeID

WHERE (((TLABRATE.EndDate)>((SELECT[EndDate] FROM [TLABRATE] WHERE [Billing
Stop] >[EndDate]))) AND ((TLABRATE.[Start Date])<((SELECT[Start Date] FROM
[TLABRATE] WHERE [Billing Stop] <[Start Date]))));

Thank you



.