Finding almost indentical entries

[PK2000]

Well here is my problem I'm doing a time keeping database and have about 13,000 entries. Some of these entries are for Callins others are for standby.
My problem is this, I've been asked to make a query that will find all standby entries that have a matching or corresponding callin entry. The database is layed out like this.

Date|Day of Week|Employee|Classification|Hourly Rate|Type|Hours|Hours Paid|Shift|Value|Time|Section|Notes|Mileage|Meals|

This would be an example line or two from the data base,
Date Day of week Employee Classification Hourly Rate Type
29-Mar-04| Fri | Lane, P | BTL | $18.00 |standby|
29-Mar-04| Fri | Lane, P | BTL | $18.00 |Callin |
03-Apr-04| Wed |Reid, J | ATA | $22.00 | Standby|

I can't do a query based on name due to the fact that everyone has multiple entries, some callins some standby some that are on the same day some that aren't. I'm totally stumped with this. Who knows maybe its something simple that I'm just not thinking of.
Anyone have any ideas?
Thanks

PK

 

[The_Doc_Man]

Well, there is an ugly way to do this. (Maybe.)

Build two queries that both have the same fields as your original table. Order both of them by date, then by person's name. Put a selection criterion on one query for Call-In only. Put a selection criterion on the other query for Standby only.

Now write a third query that finds all the records in the call-in query that have matching records in the standby query, where your select will require both the date and the name to match.

Like I said, ugly - but not impossible. For 13000 records run locally, this shouldn't even take that long to run.

 

[PK2000]

Thanks muchly. This worked perfect, definatly wasn't something I would have thought of. It doesn't help that I have basicly no knowledge of MS Access outside of what I pickup on from forums and such.
Once again.
Thanks.