I have two tables that I'm trying to combined into a report
they have the same data exept one marks an IN time and the other marks an OUT time What I need the report to show is wheather the person is in or out. Now What happens in the Query is that is shows a Time for out if they have more than one entry in. example
Cust Name: John Smith John Smith
Cust Num: 12345 12345
TimeIn 1:23:45A 1:35:56A
TimeOut 1:24:46A 1:24:46A
It automatically fills the field entry with previous time out and
should be empty
Cust Name: John Smith John Smith
Cust Num: 12345 12345
TimeIn 1:23:45A 1:35:56A
TimeOut 1:24:46A (BLANK)
Now if one entry In is the only thing listed it leaves the Out Blank
I think this is what is really confusing me.
Thanks in advance
they have the same data exept one marks an IN time and the other marks an OUT time What I need the report to show is wheather the person is in or out. Now What happens in the Query is that is shows a Time for out if they have more than one entry in. example
Cust Name: John Smith John Smith
Cust Num: 12345 12345
TimeIn 1:23:45A 1:35:56A
TimeOut 1:24:46A 1:24:46A
It automatically fills the field entry with previous time out and
should be empty
Cust Name: John Smith John Smith
Cust Num: 12345 12345
TimeIn 1:23:45A 1:35:56A
TimeOut 1:24:46A (BLANK)
Now if one entry In is the only thing listed it leaves the Out Blank
I think this is what is really confusing me.
Thanks in advance