Type Mismatch Error in Append Query 1

[Evil8]

I have the following expressions in an Append Querry that worked under Access 97, but now I get a Type Mismatch Error in Access 2003. I belive my problem is one of these.

Field: Expr1: Left(ClImport!LastName,3) & Left(ClImport!FirstName,3) & Now()
Table:
Sort:
Append To: ClientInsuredID
Criteria:
Or:

Field: Expr2: "1UPPEL1"
Table:
Sort:
Append To: ClientNum
Criteria:
Or:

Thank you in advance!

 

[xlbo]

Issue will most likely be with field data types - maybe some new ones in 2003 that didn;t exist previously. Check the data types for the table you are appending from and to - make sure they match exactly field by field

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[Evil8]

Okay thanks I figured it out. Other field formats were changed when lookup tables were intoduced.