Matching Year field in 1 query (1 Viewer)

jedder18

Just Livin the Dream!
Local time
Today, 10:58
Joined
Mar 28, 2012
Messages
135
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.
 

jedder18

Just Livin the Dream!
Local time
Today, 10:58
Joined
Mar 28, 2012
Messages
135
How does this get matched by the parameter in the QrySiteAlloc.AllocYr field?
 

jedder18

Just Livin the Dream!
Local time
Today, 10:58
Joined
Mar 28, 2012
Messages
135
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.
 

Users who are viewing this thread

Top Bottom