Hi all,
My main form is opened and based on the in put of the main form and the subform is opened. Everything is fine. But, the main form's inputs are created dummy records in one of the table.
Sceneariou: Main form : Inputs : Sample Id and collection date: (both are populated from one...
Thanks again PHV!
But the code is not working appropriately.
Description column is not retrieved with proper description, if the code is matched.
Thanks again
Many Thanks PH, Golom: Great help!
I tried with your suggestion, but it didn't work.
The query retrieves the result based on MasterCodes.CODE_TYPE)="RESUL" and this (MasterCodes.CODE_TYPE is checked with SampleDetails.RESULT_STATUS_1. The table MasterCodes is a code table. It retrieves...
Thanks PH!
I am not using SampleDetails.RESULT_STATUS_1 in my select class. Just I am selecting SELECT DISTINCT SampleDetails.UNIT_ID, SampleDetails.COLL_DATE, TestKitReagents.TEST_KIT_ID, TestBatchDetails.TEST_ID, MasterCodes.CODE_DESC, TestBatchDetails.TB_ID, SampleDetails.ABSORBANCE...
Hi,
I have a following query and it is working fine. However, I want to introduce check for the null value and replace with null value column with "NA in DB"
The query is:
SELECT DISTINCT SampleDetails.UNIT_ID, SampleDetails.COLL_DATE, TestKitReagents.TEST_KIT_ID, TestBatchDetails.TEST_ID...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.