<div>
Aren't you wanting to eliminate line 1 instead of 5?<br />
OM Gang
</div>


Aren't you wanting to eliminate line 1 instead of 5?
OM Gang

<div>
Ha! &nbsp;Yes, Sorry! &nbsp;Trying to multi-task and I'm not good at that!
</div>


Ha!  Yes, Sorry!  Trying to multi-task and I'm not good at that!

<div>
A bit confused by your data examples ...<br />
<br />
Will each weekday share the same effective date?<br />
Will it always be 5 days (Mon thru Fri) for each employee?<br />
<br />
ET
</div>


A bit confused by your data examples ...

Will each weekday share the same effective date?
Will it always be 5 days (Mon thru Fri) for each employee?

ET

<div>
<div class="content wysiwyg-content">
I have a table with the following data describing the schedule for a certain employee. &nbsp;<br />
<br />
ID* EmpID &nbsp; &nbsp; &nbsp;EffectiveDate &nbsp; &nbsp;InSched &nbsp; &nbsp; Weekday<br />
1 &nbsp; &nbsp;123 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1/1/2000 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 9:30AM &nbsp; &nbsp; &nbsp;Mon<br />
2 &nbsp; &nbsp;123 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1/1/2000 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 9:30AM &nbsp; &nbsp; &nbsp;Tue<br />
3 &nbsp; &nbsp;123 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1/1/2000 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 9:30AM &nbsp; &nbsp; &nbsp;Wed<br />
4 &nbsp; &nbsp;123 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1/1/2000 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 9:30AM &nbsp; &nbsp; &nbsp;Thu<br />
5 &nbsp; &nbsp;123 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1/1/2000 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 9:30AM &nbsp; &nbsp; &nbsp;Fri<br />
6 &nbsp; &nbsp;123 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1/1/2001 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 9:15AM &nbsp; &nbsp; &nbsp;Mon &nbsp; &nbsp; <br />
<br />
I'd like the query to eliminate line 5 because line 6 shows a newer schedule for employee 123 for Mondays.<br />
<br />
EffectiveDate and InSched fields are Date/Time fields. &nbsp;The Weekday field is just short text.<br />
<br />
Any help will be much appreciated.
</div>
</div>


I have a table with the following data describing the schedule for a certain employee.  

ID* EmpID      EffectiveDate    InSched     Weekday
1    123           1/1/2000           9:30AM      Mon
2    123           1/1/2000           9:30AM      Tue
3    123           1/1/2000           9:30AM      Wed
4    123           1/1/2000           9:30AM      Thu
5    123           1/1/2000           9:30AM      Fri
6    123           1/1/2001           9:15AM      Mon     

I'd like the query to eliminate line 5 because line 6 shows a newer schedule for employee 123 for Mondays.

EffectiveDate and InSched fields are Date/Time fields.  The Weekday field is just short text.

Any help will be much appreciated.

Simple Access Query

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.