Adding numbers from Different Tables

[Guest]

I am trying to add two fields togeather from different tables that and
display the records which the total of the two fields are less than 130.
When I so the query on the main table I get the records, as soon as I link
the table to the other table to get the other field, I get no records at all.
Please help!

 

[Denis Dougall]

Show us your SQL, please.

Denis

 

[Guest]

SELECT CALL_COUNT_SUMMARY_BY_ISR.supervisor,
CALL_COUNT_SUMMARY_BY_ISR.supervisorName, CALL_COUNT_SUMMARY_BY_ISR.salesman,
CALL_COUNT_SUMMARY_BY_ISR.salesmanName, CALL_COUNT_SUMMARY_BY_ISR.scheduled,
CALL_COUNT_SUMMARY_BY_ISR.scheduledProductiveAssignedISR,
CALL_COUNT_SUMMARY_BY_ISR.scheduledProductiveOtherISR,
CALL_COUNT_SUMMARY_BY_ISR.scheduledProductiveCSR,
CALL_COUNT_SUMMARY_BY_ISR.scheduledUnproductive,
CALL_COUNT_SUMMARY_BY_ISR.scheduledRemaining,
CALL_COUNT_SUMMARY_BY_ISR.remainingPeriod1,
CALL_COUNT_SUMMARY_BY_ISR.remainingPeriod2,
CALL_COUNT_SUMMARY_BY_ISR.remainingPeriod3,
CALL_COUNT_SUMMARY_BY_ISR.remainingPeriod4,
CALL_COUNT_SUMMARY_BY_ISR.remainingPeriod5,
CALL_COUNT_SUMMARY_BY_ISR.remainingPeriodOther,
CALL_COUNT_SUMMARY_BY_ISR.isrProductiveAssignedRoutes,
CALL_COUNT_SUMMARY_BY_ISR.isrProductiveOtherRoutes,
CALL_COUNT_SUMMARY_BY_ISR.isrUnproductiveAllRoutes
FROM CALL_AllocationCHG INNER JOIN CALL_COUNT_SUMMARY_BY_ISR ON
CALL_AllocationCHG.[NEW_S#] = CALL_COUNT_SUMMARY_BY_ISR.salesman
WHERE
(((CALL_COUNT_SUMMARY_BY_ISR.scheduled)=([call_count_summary_by_isr].[scheduled]+[CALL_AllocationCHG].[New_Allo_No])));

 

[John Vinson]

I am trying to add two fields togeather from different tables that and
display the records which the total of the two fields are less than 130.
When I so the query on the main table I get the records, as soon as I link
the table to the other table to get the other field, I get no records at all.
Please help!

How are you linking the tables? Do you have a common field which
uniquely identifies which record in the first table should be linked
to which record in the second?

John W. Vinson[MVP]

 

[Denis Dougall]

change your where clause to ..

where
sum([call_count_summary_by_isr].[scheduled]+[CALL_AllocationCHG].[New_Allo_N
o]) <130;

SELECT CALL_COUNT_SUMMARY_BY_ISR.supervisor,
CALL_COUNT_SUMMARY_BY_ISR.supervisorName, CALL_COUNT_SUMMARY_BY_ISR.salesman,

CALL_COUNT_SUMMARY_BY_ISR.salesmanName,

CALL_COUNT_SUMMARY_BY_ISR.scheduled,
CALL_COUNT_SUMMARY_BY_ISR.scheduledProductiveAssignedISR,
CALL_COUNT_SUMMARY_BY_ISR.scheduledProductiveOtherISR,
CALL_COUNT_SUMMARY_BY_ISR.scheduledProductiveCSR,
CALL_COUNT_SUMMARY_BY_ISR.scheduledUnproductive,
CALL_COUNT_SUMMARY_BY_ISR.scheduledRemaining,
CALL_COUNT_SUMMARY_BY_ISR.remainingPeriod1,
CALL_COUNT_SUMMARY_BY_ISR.remainingPeriod2,
CALL_COUNT_SUMMARY_BY_ISR.remainingPeriod3,
CALL_COUNT_SUMMARY_BY_ISR.remainingPeriod4,
CALL_COUNT_SUMMARY_BY_ISR.remainingPeriod5,
CALL_COUNT_SUMMARY_BY_ISR.remainingPeriodOther,
CALL_COUNT_SUMMARY_BY_ISR.isrProductiveAssignedRoutes,
CALL_COUNT_SUMMARY_BY_ISR.isrProductiveOtherRoutes,
CALL_COUNT_SUMMARY_BY_ISR.isrUnproductiveAllRoutes
FROM CALL_AllocationCHG INNER JOIN CALL_COUNT_SUMMARY_BY_ISR ON
CALL_AllocationCHG.[NEW_S#] = CALL_COUNT_SUMMARY_BY_ISR.salesman
WHERE
(((CALL_COUNT_SUMMARY_BY_ISR.scheduled)=([call_count_summary_by_isr].[schedu
led]+[CALL_AllocationCHG].[New_Allo_No])));

Show us your SQL, please.

Denis
at
all.