Shannon3778
Registered User.
- Local time
- Today, 14:44
- Joined
- Dec 13, 2012
- Messages
- 29
I have 2 tables in my database. One is a predicted table that gives the predictions for staffing, etc. The 2nd table shows the actual results. I've created a "Before" query and an "After Query" showing me only the fields that I need to see compared. Now I can't figure out how to find differences. I need to see if schedules changed and if new rows were added or rows were deleted. I've tried the unmatch query and it only brings back the fields that were not blank in the before query and are blank in the after. It won't return any other results! HELP?!?!:banghead: