Matching Year field in 1 query

[jedder18]

Using Access 07

This is my query

SELECT QrySiteAlloc.Site, QrySiteAlloc.AllocYr, QrySiteAlloc.SiteAllocation, Sum(QryReserveTotals.SumOfAddtlAllocationAmt) AS SumOfSumOfAddtlAllocationAmt
FROM QrySiteAlloc LEFT JOIN QryReserveTotals ON QrySiteAlloc.Site = QryReserveTotals.Site
GROUP BY QrySiteAlloc.Site, QrySiteAlloc.AllocYr, QrySiteAlloc.SiteAllocation;



in the QryReserveTotals is a datereceived field.
I need the year of the date received field to match the QrySiteAlloc.AllocYr that will be selected by a parameter..

what would be the criteria to achieve this?

Thanks in advance for any and all help.

 

[spikepl]

Year(MyDateReceived)

 

[jedder18]

How does this get matched by the parameter in the QrySiteAlloc.AllocYr field?

 

[jedder18]

I solved this.
This was a report based on numerous queries to get final result.
I created a new field in the 3 different beginning queries
datepart("yyyy",respectivefld)
Those fields had to match each other in the remaining queries.
Report calls the rptyear parameter which picks up the correct data now.