Question on linking query's

Hello,

I am hoping someone can help me, I have 2 tables I am working with the first table has a total of part a, b, c, etc and the date it is representing. Table 2 has the details for that date. Does anyone know a way I can link the date in table 1 to the data in table 2 via the date. I was able to change the date in the first table to a link but unable to find a hyperlink to the 2nd table that allows it to only bring up the date in question.
Any advise is appreciated.
Thanks