By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
444,154 Members | 2,313 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 444,154 IT Pros & Developers. It's quick & easy.

Comparing 2 Tables in a Query

P: 36
Hi Everyone,

I know there's been a lot of questions regarding the same kind of issue but I haven't been able to find an answer to my specific problem. Basically I have two tables, one table showing planned hours for a week and one table showing actual hours for that week.
At the beginning of each week employees are supposed to fill out the hours the expect to spend on each task. Then at the end of the week, they input the actual hours they spent on each task. This is done through a form which goes into the tables mentioned above. At the end of the month/year, we want to be able to compare how accurate the planned hours were compared to the actual hours. I think I have to do something regarding a find unmatched query, but I also need to be able to see the matched items as well. Below are my tables with their respective fields, as well as something along the lines of what I'm trying to make the query look like. (table, fields)

Planned Table
Week
Specific Task
Region
Hours


Actual Table
Week
Specific Task
Region
Hours



Hopefully the query can look something like this (I don't know how to do a table layout in the form yet so hopefully you get the idea


Week....... Specific Task............ Region..... Planned Hours.......... Actual Hours
8/6/2007... Meeting.................... AB........... 6.............................. 6
8/6/2007... Budget..................... AB........... 4.............................. 3
8/6/2007... Budget..................... BC........... 0.............................. 1

If anyone could tell me if there is a way to do this, I would really appreciate it.

Thanks,
Tiffany
Aug 9 '07 #1
Share this Question
Share on Google+
3 Replies


Rabbit
Expert Mod 10K+
P: 12,383
Why not have an extra field in one table and then you can have a PlannedHours and ActualHours field? Then you can get rid of the other table.
Aug 9 '07 #2

P: 36
That would provide a much simpler solution. I'll see if I can set it up in my form. Thanks for the advice
Aug 9 '07 #3

Rabbit
Expert Mod 10K+
P: 12,383
That would provide a much simpler solution. I'll see if I can set it up in my form. Thanks for the advice
You'll have to change your table structure too, adding a new field.
Let us know if you run into any trouble.
Aug 9 '07 #4

Post your reply

Sign in to post your reply or Sign up for a free account.