Find Max Values and Return Null Value Too

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!!!
 
Try something along the lines of
SELECT etc
FROM YourTable
WHERE yourColumn IN (SELECT Max(yourColumn) FROM YourTable)
OR yourCoulmn Is Null;

Hope This Helps
Gerald Stanley MCSD
-----Original Message-----
I'm trying to create a query that will find the maximum
Click to expand...
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
Click to expand...
records where the same field is null??
 
Back
Top