Forms: To Show Specific Fields

[netchie]

Hi,



My main menu shows the window as to which data needs follow-up based from it's ScheduledFollowUpDate and Status. I only need to show anything that has Status of "On-going" with blank ScheduledFollowUpDate (no date) but I am having a hard time to show both. What I have below shows all "On-going" but with FollowUpDate that is not blank.

SELECT tCARs.CarNo, tCARs.ScheduledFollowUpDate, tCARs.CreationDate, tCARs.Frequency, tCARs.Status
FROM tCARs
WHERE (((Date())>=tCARs.ScheduledFollowUpDate-14)) AND tCARs.Status="On-going"
ORDER BY tCARs.ScheduledFollowUpDate;

I know I am missing for my ScheduledFollowUpDate that should have blank date but I don't know how to do it. Can you please help me?

Thanks,
netchie

[pbaldy]

How about:

WHERE tCARs.ScheduledFollowUpDate Is Null AND tCARs.Status="On-going"

[netchie]

Hi pbaldy,

Thanks for helping me again.

It worked... it worked... it worked!!!!

Thanks again and more to come from me hehehe.

Thanks,
netchie

[pbaldy]

Happy to help Nanette!