Show null in Select Query.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

jenn.semo@gmail.com - 13 Jul 2006 02:17 GMT

SELECT Requests.[Date Time], Requests.Status, Min(Responses.Date) AS
MinOfDate, Max(Responses.Date) AS MaxOfDate, Requests.[Request ID]
FROM Requests INNER JOIN Responses ON Requests.[Request ID] =
Responses.[Request ID]
GROUP BY Requests.[Date Time], Requests.Status, Requests.[Request ID];

Above is my query. I need to be able to view records when the
Responses table has a null value. Any idea what I need to do to get to
this point? I have very, very little experience with Access.

Thank you so much!

Reply to this Message

Ken Snell (MVP) - 13 Jul 2006 02:40 GMT

Use a LEFT JOIN:

SELECT Requests.[Date Time], Requests.Status, Min(Responses.Date) AS
MinOfDate, Max(Responses.Date) AS MaxOfDate, Requests.[Request ID]
FROM Requests LEFT JOIN Responses ON Requests.[Request ID] =
Responses.[Request ID]
GROUP BY Requests.[Date Time], Requests.Status, Requests.[Request ID];

Signature

Ken Snell
<MS ACCESS MVP>

> SELECT Requests.[Date Time], Requests.Status, Min(Responses.Date) AS
> MinOfDate, Max(Responses.Date) AS MaxOfDate, Requests.[Request ID]
[quoted text clipped - 7 lines]
>
> Thank you so much!

Reply to this Message

Jenn - 13 Jul 2006 02:53 GMT

This absolutely worked for me. Thank you so much!

> Use a LEFT JOIN:
>
[quoted text clipped - 20 lines]
> >
> > Thank you so much!

Reply to this Message