I am using Access 2000 and have a database that has 2 tables linked by an ID Number on a one to many basis. In the first table, the ID Number field is unique for each record, but there are several fields in each record that contain dates. The second table has the following fields: ID Number, Text, Date. There can be multiple records in the second table that have the same ID Number with different values in the Text and Date fields. I want the user to enter a start and end date and then be able to print a report that would look similar to the following: ID Number Field Name Date (From the first table) Field Name Date (From the first table) Field Name Date (From the first table) Text Date (From the second table) Text Date (From the second table) Each ID Number would appear in the report only if there were dates in itâ€™s fields in table one that had dates equal to or between the start and end dates entered and/or dates in table two that met the same criteria. If a field from table one or from table two did not meet the criteria entered, it should not appear in the report. Is this possible? If so, how? Any help will be greatly appreciated.