Month Date Link Help

[Guest]

I have two tables that I would Like to link by Month and year. So if I have a
Date of 1 Jan 05 in one table and a date of 10 Jan 05 in the 2nd table they
would link.

one field is [B_Date] and the 2nd is [CW_St_Time]

Thanks

 

[Rick Brandt]

I have two tables that I would Like to link by Month and year. So if I have a
Date of 1 Jan 05 in one table and a date of 10 Jan 05 in the 2nd table they
would link.

one field is [B_Date] and the 2nd is [CW_St_Time]

You can do joins on expressions but they are not efficient and you can't create
such a query in the graphical query designer. Just create the query in the
designer joining on the date fields and then switch to SQL view and change the
join to something like...

From Table1 Join Table2
On Format([Table1]![B_Date], "yyyy-mm") = Format([Table2]![CW_St_Time],
"yyyy-mm")

 

[Guest]

Thanks for your Help Rick!

Keith

I have two tables that I would Like to link by Month and year. So if I have a
Date of 1 Jan 05 in one table and a date of 10 Jan 05 in the 2nd table they
would link.

one field is [B_Date] and the 2nd is [CW_St_Time]

You can do joins on expressions but they are not efficient and you can't create
such a query in the graphical query designer. Just create the query in the
designer joining on the date fields and then switch to SQL view and change the
join to something like...

From Table1 Join Table2
On Format([Table1]![B_Date], "yyyy-mm") = Format([Table2]![CW_St_Time],
"yyyy-mm")