Help with Count (2007)

[wgma]

I need some help with a query. I usually work with MS SQL but I need to use ACCESS 2007 this time.

I have one table.
I query three fields in the table.
I have to use at least 2 queries.

Here are my queries:

Query
SELECT WGMAHIST_TIMEDTY.TDYEDT AS [Work End],
(SELECT Count(*) FROM qryNbrOfMen1) AS MEN,
SUM(WGMAHIST_TIMEDTY.TDYFND) AS HRS
FROM WGMAHIST_TIMEDTY
WHERE WGMAHIST_TIMEDTY.TDYEDT Between 20060101 And 20061231 And WGMAHIST_TIMEDTY.TDYLCL In (24,28,1351) AND WGMAHIST_TIMEDTY.TDYCO = 92
Group By WGMAHIST_TIMEDTY.TDYEDT
order by WGMAHIST_TIMEDTY.TDYEDT


qryNbrOfMen1
SELECT DISTINCT WGMAHIST_TIMEDTY.TDYSSN
FROM WGMAHIST_TIMEDTY
WHERE (((WGMAHIST_TIMEDTY.TDYEDT)=20060113) AND ((WGMAHIST_TIMEDTY.TDYLCL) In (24,28,1351)) AND ((WGMAHIST_TIMEDTY.TDYCO)=92))
GROUP BY WGMAHIST_TIMEDTY.TDYSSN

Everything works great but I need the date in the line, WHERE (((WGMAHIST_TIMEDTY.TDYEDT)=20060113) AND, to use the date in the first query.

In SQL it would look something like this:

SELECT WGMAHIST_TIMEDTY.TDYEDT AS [Work End],
Count(SELECT DISTINCT WGMAHIST_TIMEDTY.TDYSSN
FROM WGMAHIST_TIMEDTY
WHERE (((WGMAHIST_TIMEDTY.TDYEDT)=[Work End]) AND ((WGMAHIST_TIMEDTY.TDYLCL) In (24,28,1351)) AND ((WGMAHIST_TIMEDTY.TDYCO)=92))
GROUP BY WGMAHIST_TIMEDTY.TDYSSN
) AS MEN,
SUM(WGMAHIST_TIMEDTY.TDYFND) AS HRS
FROM WGMAHIST_TIMEDTY
WHERE WGMAHIST_TIMEDTY.TDYEDT Between 20060101 And 20061231 And WGMAHIST_TIMEDTY.TDYLCL In (24,28,1351) AND WGMAHIST_TIMEDTY.TDYCO = 92
Group By WGMAHIST_TIMEDTY.TDYEDT
order by WGMAHIST_TIMEDTY.TDYEDT

How can I do this in Access 2007?

Thanks.