How to return Max date or Null (if there is a Null present)

Hi,

I have a query where I Group By an Equipment Number field and then, for each equipment Number, return the Max (latest) Forecast Delivery date.

The problem is where one or more entries for a given Equipment Number has a Null in the Forecast Delivery date field. In these cases I need to return Null.

So, I need something like: "Return Max if there is no Null, otherwise return Null" for my Forecast Delivery field.

I have no idea how to do this Access so any help would be greatly appreciated.

Thanks very much.

Dave


.

Relevant Pages

  • Re: How to return Max date or Null (if there is a Null present)
    ... I have a query where I Group By an Equipment Number field and then, for each equipment Number, return the Max Forecast Delivery date. ... Microsoft's replacements for these newsgroups: ...
    (microsoft.public.access.queries)
  • Re: DB Result Wizard Error
    ... Also noted that one folder, which contains no information can't be deleted, ... >> For instance Equipment Serial Number, Equipment Model Number, Cost Accounting ... >> to display the new equipment information. ... >> is in the table was added to the query. ...
    (microsoft.public.frontpage.programming)
  • Re: How do I sort a report grouping on a calculated value?
    ... need a pivot table to count the number of records in a group? ... Find your query that calculates your counts. ... To find the count of equipment per V-Name, ... Save this totals query and then add it to your report's record source ...
    (microsoft.public.access.reports)
  • Re: Run query or report from multiple tables
    ... Make another query? ... to the SystemNumbers table - has a link to each record in the Instruments ... SubSystemNo) it won't be listed. ...
    (microsoft.public.access.queries)
  • Re: Expression in SQL or user-defined function?
    ... SeqLetter comes from the subform, and is assigned automatically when a new subform record is created, so no problem there. ... standard query, and you are calling it from an event in a subform, it is just ... Public Function EquipNumber (strDeptCode as String, lngSeqNumber as Long, ... Equipment for the machining department is>> numbered ...
    (microsoft.public.access.formscoding)