hrdpgajjar
Registered User.
- Local time
- Tomorrow, 00:31
- Joined
- Sep 24, 2019
- Messages
- 142
Hi all,
I have a table named "Master Data" having following columns
- Regi No
- Farmer Name
- MIS System
- Material Supply Date
- DD Or RTGS No
- Material Supply Date
- TPA Date
I am trying to run a query where,
- Material Supplied (Not Null)
-DD Or RTGS No Pending (Is Null)
- TPA Date pending (Is null)
It works properly but as is select "DD Or Rtgs No" as "Is Null"
it returns blank report.
Earlier this query works fine but suddenly stops working
Below is my SQL View
SELECT [Master Data].[DD Or Receipt No], [Master Data].[Material Supply Date], [Master Data].[WO Date], [Master Data].[TPA Date], [Master Data].[Regi No], [Master Data].[Farmer Name], [Master Data].[MIS System]
FROM [Master Data]
WHERE ((([Master Data].[DD Or Receipt No]) Is Null) AND (Not ([Master Data].[Material Supply Date]) Is Null) AND (Not ([Master Data].[WO Date]) Is Null) AND (([Master Data].[TPA Date]) Is Null));
There are some records having above criteria but it shows blank
help appreciated
Thanks
I have a table named "Master Data" having following columns
- Regi No
- Farmer Name
- MIS System
- Material Supply Date
- DD Or RTGS No
- Material Supply Date
- TPA Date
I am trying to run a query where,
- Material Supplied (Not Null)
-DD Or RTGS No Pending (Is Null)
- TPA Date pending (Is null)
It works properly but as is select "DD Or Rtgs No" as "Is Null"
it returns blank report.
Earlier this query works fine but suddenly stops working
Below is my SQL View
SELECT [Master Data].[DD Or Receipt No], [Master Data].[Material Supply Date], [Master Data].[WO Date], [Master Data].[TPA Date], [Master Data].[Regi No], [Master Data].[Farmer Name], [Master Data].[MIS System]
FROM [Master Data]
WHERE ((([Master Data].[DD Or Receipt No]) Is Null) AND (Not ([Master Data].[Material Supply Date]) Is Null) AND (Not ([Master Data].[WO Date]) Is Null) AND (([Master Data].[TPA Date]) Is Null));
There are some records having above criteria but it shows blank
help appreciated
Thanks