I think you need to provide some context and sample data as well as desired
results. Sum and Max work against a group of records while "another field is
null" seems to work against just a single record.

--
Duane Hookom
Microsoft Access MVP


"Barry" wrote:

I would like to make a query on a table on one field to 'sum' or 'max' the
field based on 'if' another field is null or not. Any idea on how I would
go about this? Please be generous as I am not an Access expert :-)
--
Barry