NULL FIELDS

M

maple leaf 13

I have a table that is linked to an ODBC source that has a field that can
either have characters or null. I also have a field in the that same table
that I am using for grouping records. When I attempt to run queries based on
the grouping field it will split the like groups when the other field is null.

For example:
Field 1 Field 2 Field 3
AB1 Other 50.00
BC2 Other 25.00
Other 100.00

When i run a query that groups by field 2 and sums field 3 the results i get
are:

Other 75.00
100.00

Any suggestions on why this may be happening?

thanks.
 
M

maple leaf 13

SELECT qry_CummulativeTotals_AllSpecMgrForm.[Total PDC Collected],
qry_CummulativeTotals_AllSpecMgrForm.[Total Revenue],
qry_CummulativeTotals_AllSpecMgrForm.Name,
qry_CummulativeTotals_AllSpecMgrForm.[MTD Collected],
qry_CummulativeTotals_AllSpecMgrForm.[Total Collected],
qry_CalcProfitSharing_Total_Mgr.[Total Profit Sharing]
FROM qry_CalcProfitSharing_Total_Mgr INNER JOIN
qry_CummulativeTotals_AllSpecMgrForm ON
qry_CalcProfitSharing_Total_Mgr.UserID2 =
qry_CummulativeTotals_AllSpecMgrForm.UserID2;

Hope this helps.

Thanks
 
Top