Recent content by hrdpgajjar

Thanks for the reply, Following query works for me, SELECT DealerT.DealerID, DealerT.DealerName, ProductT.ProductID, ProductT.ProductName, ProductT.Unit, Nz((SELECT Sum(RDCOrderT.Quantity) FROM (DealerT AS d INNER JOIN DispatchOrderT ON...

I have two tables RDC Material Table and GGRC Material Table and I am trying to find out balance stock (RDC Material - GGRC material). attached herewith my database file for your reference. Thanks

Two Tables required because there are two different types of Material supply, 1. RDC Material Supply Stock 2. GGRC Material Supply Stock And i need to find out the balance stock between two i.e. RDC Material Stock - GGRC Material Stock

Hi all, I have created two queries with two different table values as under, 1. RDC Material Table 2. GGRC Material Table Now i have created two query for sum of total material for each table as , 1. DealerWiseRDCMaterialSummary 2. DealerWiseGGRCMaterialSummary each table/ query has...

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