Type mismatch in Expression error

Posted on 2007-10-05
Medium Priority
Last Modified: 2012-06-27
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
Question by:kdeutsch
LVL 33

Expert Comment

ID: 20022218
Post you SQL Statement
LVL 61

Expert Comment

ID: 20022509
Please post details regarding what actions trigger this error, when you are receiving it, and any relevant VBA or SQL.

Accepted Solution

kdeutsch earned 0 total points
ID: 20022803
ok, i fixed the error by changing the datafields in the soldier Id field to number instead of text in the awards given table.  
LVL 61

Expert Comment

ID: 20022862

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:


Expert Comment

ID: 20176368
Closed, 125 points refunded.
Community Support Moderator

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
Suggested Courses

840 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question