query to select the date from two tables on the criteria basis.

[sarohap]

Hi all,

Please help me to get the data from two tables on the basis of criteria...

I want to select the whole table1 which has 6 fields including Emp_id...
I want to select the single field from table2. field name is "Username" from second table2. will select the username on the basis of Emp_ID becaue both tables has same emp_ID.

It should be in order like. Emp id, Username, Startdate, Enddate, Hours, trainingNames.....

I hope its clear to given the answer. if its not clear please let me know so i can provide you explained details.

 

[plog]

Since its hard to fully express yourself with just the written word, let me explicitly say the next sentence isn't a put down: Your question seems super trivial and something you should be able to do yourself. You're question is a Catch-22--you've provided such a good explanation of what you want, I don't think someone with your aptitude should be asking it.

I'm all for helping someone so here is a query tutorial link: http://www.makeuseof.com/tag/quick-tutorial-queries-microsoft-access-2007/. And if you still need help, post back what you've done to achieve it and what issues you are having with your specific attempt. Again, not a put down, just confusing because you seem to have a great grasp of what you want and what you want is really simple.