Find Max Values and Return Null Value Too

[Josiah]

I'm trying to create a query that will find the maximum value for a field and if that field is null it will still display the record but the max will be blank. In Access, using the "Totals" and selecting the totals type as "Max", works except it does not display null values. I've tried using dmax too with no luck

How can I find the max value for a field and include records where the same field is null?

Any help would greatly be appreciated!!!