K
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
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