Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Mismatch

Status
Not open for further replies.
cjmcfg

cjmcfg

IS-IT--Management
Joined
May 21, 2007
Messages
26
Location
US
I have an employee list and i need to make a query so that if a name in the employee list is not listed in another table then to append it...how do i do this?
 
Sort by date Sort by votes
There is a wizard when creating a new query [tt]"Find Unmatched Query Wizard"[/tt].

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Fireman1143
  • Locked
  • Question Question
Type Mismatch message
Replies
2
Views
257
Fireman1143
Fireman1143
abenitez77
  • Locked
  • Question Question
recordset type mismatch
Replies
4
Views
249
abenitez77
abenitez77
btrini10
  • Locked
  • Question Question
Data Type Mismatch error
Replies
1
Views
85
traingamer
traingamer
AlanJordan
  • Locked
  • Question Question
Error 3464 Data type mismatch in criteria expression
Replies
3
Views
206
dhookom
dhookom
dceglar1
  • Locked
  • Question Question
Data Type Mismatch in Criteria Expression 3464
Replies
9
Views
282
dceglar1
dceglar1

Part and Inventory Search

Sponsor

Back
Top