join 2 querys in one query

[hatmal]

---

i have



Movements_during_qry ------ movments to all employee during day

Movements_qry------- which including arrival in morning and depature in end day


how i combine two query’s in one query to show data

example
in day 05/02/2015 show employee 1 show all movements and arrival

( from 2 querys)

file[/url"]http://www.access-programmers.co.UK/forums/attachment.php?attachmentid=57519&d=1424607682

[June7]

Perhaps you need to do a compound join on employeeID and date fields.

What is that link supposed to open?

[hatmal]

file attached

[June7]

I have the db file but I don't understand the data structure. What are Movements_tb and Movements_during_tb representing?

[hatmal]

I have the db file but I don't understand the data structure. What are Movements_tb and Movements_during_tb representing?

Movements_tb------------ for show employee arrival in morning and end of day


Movements_during_tb------- for employee who in in time in day examplyee


employee 1 will take permission from work from 10:00 morning to 11:00

[June7]

Provide an example of what the output should look like.