Query two tables for specified dates

[funkygoorilla]

Hi,
I have two tables that have date ranges I would like to query certain parts of. One table A has a begin date, and end date, and table B has a date for all entries made on that day. Is there a way I can have one query look at table A, for entries made between ##/##/#### and ##/##/####, and look in table B for all entries between ##/##/#### and ##/##/####? I would like to have the user enter only two date ranges, but have the query pull results from two tables. Thanks for any help.

[dblife]

Assuming you have a form based on table A you wish to work from, create two unbound text boxes, have these as the criteria for the forms record source.
When the users selects dates, have a subform show entries for that date via a parent/child relationship based on date.

[funkygoorilla]

Ok to clarify, I have table A with only one date of when the users enters the info. Its information relating to when they start a shift on the job. The next table stores info for what they did on the job and the dates of it. The problem is that I can query table B for the date span, but I dont know who to include the date from table A in that same span.