Search results

Many thanks, everything works perfectly now. Learn a lot from this. Never imagined that "ZLS" could affect this much. anyways, thanks for the big assist Cheers!!!

I have changed property of "DD_ReceiptNo" allow zero length to no and run query still getting incorrect data. Can u please attach my database with working query for my understanding ? thanks

thanks, will do it at first.

if i go with "OR" the result is going wrong. Is there anything i can do?

Please short records manually. there are 52 records as per my needs.

When i add one more criteria i.e. WO Date = not is null it gives zero records. where actually there are 52 records in data base. below is my new query, SELECT [Master Data].[Regi No], [Master Data].[MATERIAL SUPPLY DATE], [Master Data].[TPA DATE], [Master Data].[DD_RECEIPTNO], [Master...

Attached my Database herewith, please create a query with the following criteria, 1. Material Supply Date - Not null 2. TPA Date - Is Null 3. DD_ReceiptNo - Is Null help appreciated Thanks

Still not getting the result i want. Is there problem in count null or not null values in "Short Text" type ?

Now the bigger question for newbee like me is, How to handle null values in a proper way in a data base ??? what is the best way to sort "Null" And "Not null" values in a large database?

SELECT [Regi No],[DD_ReceiptNo],[WO Date] FROM [Master Data] WHERE NOT ISNULL ([DD_ReceiptNo]) This still returns both null and not null values in (DD_ReceiptNo)....

SELECT [Master Data].[Regi No], [Master Data].DD_ReceiptNo, [Master Data].[WO Date], [Master Data].[TPA Date], [Master Data].[Farmer Share Deposite Date] FROM [Master Data] WHERE ((([Master Data].DD_ReceiptNo) Is Not Null)); Still it returns both fields having value or not having value (null)...

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...

based on little experience i have in access queries, this is the best and only hassle free work around. Create a table and get whatever you want. will definitely consider this as a solution too. Thanks for the reply.

This works as i want. Thanks for your support as always.

means i need to create three different queries and then create a new query to make total of three queries? is there any alternative ?

Hi all, I have a table name FinalPaymentT having following columns, - FarmerShareRcvdDate - FarmerShareAmount - PFMSRcvdDate - PFMSAmount - StateTopUpRcvdDate - StateTopUpAmount I need Total of Three Amounts (FarmerShareAmount + PFMSAmount + StateTopUpAmount) sort by three dates where, Dates...

This works as i want, thanks

This gives result with both field has value, i need RTGSMAIL field with no value

without joining FarmerT it works flowless, but when i join them it becomes mess

Hi all, I have two tables 1. FarmerT And 2.RTGST FarmerT has a field "RegNo" And RTGST has two fields "RTGSUTR1" And "MailToHO1" Now i need a data having following criteria, - No of cases (RegNo) where "MailToHO1" is not null and "RTGSUTR1" is null this returns as zero records, but actually...