Type mismatch in Expression error

I rredesigned my database so that a individual can have multiple awards instead of entering a award in every single instance.  Folowing are my datafields of the two tables.  I have the relationship as a one to many relationship from soldier ID to Soldier ID.    Here are the fields.
Employee fields
Soldier Id      LNAME      FNAME      Rank      Command      Unit      Position Title      GradeType GradeLevel

Awards Given Fields
Award Id      Soldier ID      DateReceived      DateApproved      DatetoTag      DatetoAcc TypeofAward      Dollaraward      Hours      GradeStep      FYAward      StategicObjective   Notes
kdeutschAsked:
Who is Participating?
 
kdeutschConnect With a Mentor Author Commented:
ok, i fixed the error by changing the datafields in the soldier Id field to number instead of text in the awards given table.  
0
 
hongjunCommented:
Post you SQL Statement
0
 
mbizupCommented:
Please post details regarding what actions trigger this error, when you are receiving it, and any relevant VBA or SQL.
0
 
mbizupCommented:
kdeutsch,

Please post a question at this link, stating that you answered your own question and requesting that this question be closed with the points refunded:

http://www.experts-exchange.com/Community_Support/General/
0
 
Vee_ModCommented:
Closed, 125 points refunded.
Vee_Mod
Community Support Moderator
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.