S
Steve D
Hi,
I have 2 tables one contains the following fields "Month", "Start Date",
"End Date" the second contains data with week ending dates. Each month should
contain 4 or 5 week ending dates. Is there a way to create a query that
queries data based on a month. For example I want January to be my criteria
and January is valid in the "Month" field of the first table and I want it to
bring back any data in the data table where the week ending date is between
the "start date" and "end date" in the first table. Is this possible? And if
so how do I do it? I do not see a way to join the tables.
I have 2 tables one contains the following fields "Month", "Start Date",
"End Date" the second contains data with week ending dates. Each month should
contain 4 or 5 week ending dates. Is there a way to create a query that
queries data based on a month. For example I want January to be my criteria
and January is valid in the "Month" field of the first table and I want it to
bring back any data in the data table where the week ending date is between
the "start date" and "end date" in the first table. Is this possible? And if
so how do I do it? I do not see a way to join the tables.