Design (?) Question

[Bunky]

I was asked to match two files today that are not in the same format and I am
stumped as to how to proceed.

File 1 is Inventory Available. It contains the project(resort number), the
unit number, the unit type and the day available. It can have multiple
records for a unit if that unit is unoccupied for the time frame being
examined.

Example
resort unit Date Unit Type
01 b306 05/05/07 E
01 b306 05/06/07 E

File 2 is Inventory Requested. It contains, among other things, the resort,
unit type
and the dates requested on ONE record.

Example

resort Unit type Check-In data number of nights
01 E 05/05/07 2

The optimum would be to be able to come up with a list of perfect matches
and as I showed in the example; this is a perfect match. But how do I get
the 1st file to show just 1 record so I can do the matching??

Thank you for your assistance!

 

[KARL DEWEY]

Join on Resort and Unit Type then use Check-In date as criteria for
Date

 

[Bunky]

Thats what I thought. . . Thanks!

Join on Resort and Unit Type then use Check-In date as criteria for
Date

 

[Tom Wickerath MDB]

if you want to properly design a database, then do it in SQL Server

Access MDB is obsolete, and it has been for a decade