NULL FIELDS

[Guest]

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.

 

[Guest]

That shouldn't happen, unless you have a Null value in Field2, open the
table, sort it Asc by Field2 and see what are the first records you are
getting, and if there are Nulls in field2.

Can you post the full SQL?

 

[Guest]

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