G
Guest
I'm stumped and I'm hoping someone can help me. I have to use a
multi-conditional expression within a query to compare records in two
different tables that are not unique and return a result:
I have to compare two fields in Table1 (CampID & SiteID) to two similar
fields in Table2 and if both values match return a value for a third field in
Table1 (EstimatedAttendants). So essentially I need something that does the
following:
If Table1!CampID=Table2!CampID
AND If Table 1!SiteID=Table2!SiteID
then show the result of (Table1!EstimatedYouth+Table1!EstimatedAdults)
I don't know if this is possible, but I appreciate any help I can get.
multi-conditional expression within a query to compare records in two
different tables that are not unique and return a result:
I have to compare two fields in Table1 (CampID & SiteID) to two similar
fields in Table2 and if both values match return a value for a third field in
Table1 (EstimatedAttendants). So essentially I need something that does the
following:
If Table1!CampID=Table2!CampID
AND If Table 1!SiteID=Table2!SiteID
then show the result of (Table1!EstimatedYouth+Table1!EstimatedAdults)
I don't know if this is possible, but I appreciate any help I can get.