Update Query

[KimTong via AccessMonster.com]

Hi,

I have table1 with ID1, FlightDate (Date) and table2 with ID2 and FlDt (Text).
I'd like to update Field table1 to table2 using Update Query Like this:

Field : ID1 FDate: Format(FlightDate,
"yyyymmdd")
Table : table1
Update To : [table2].[FlDt] [table2].[FlDt]

When I run this query, the message says 'Format(FlightDate,"yyyymmdd") is not
valid name.Make sure it doesn't include invalid chareater or puncuation and
that it is not too long'.

Is anyone can help me how to fix that? Thank you in advance.

KF

 

[Guest]

Post your complete query SQL.

 

[KimTong via AccessMonster.com]

Hi,

THank you for the respond. Here is the SQL script of my Update Query:

SELECT [AWB MDC].AwbNbr, Format([FlightDate],"yyyymmdd") AS [Flight Date]
FROM AWB, [AWB MDC]
WHERE ((([AWB MDC].AwbNbr)=[AWB]![AWB#]) AND ((Format([FlightDate],"yyyymmdd")
)=[AWB]![Unknown2]));

It shows in Design view query, but when I click ! (RUN query ), access gives
me the message:
'Format(FlightDate,"yyyymmdd") is not valid name.Make sure it doesn't include
invalid chareater or puncuation and that it is not too long'

KF

Hi,

I have table1 with ID1, FlightDate (Date) and table2 with ID2 and FlDt (Text).
I'd like to update Field table1 to table2 using Update Query Like this:

Field : ID1 FDate: Format(FlightDate, >"yyyymmdd")
Table : table1
Update To : [table2].[FlDt] [table2].[FlDt]

When I run this query, the message says 'Format(FlightDate,"yyyymmdd") is not
valid name.Make sure it doesn't include invalid chareater or puncuation and
that it is not too long'.

Is anyone can help me how to fix that? Thank you in advance.

KF