Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: senthilmuruganv
- Order by date
-
dummy records added in the table - Form opening/querying
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...- senthilmuruganv
- Thread
- Replies: 1
- Forum: Microsoft: Access Forms
-
IsNull and replace with "Text"
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- senthilmuruganv
- Post #8
- Forum: Microsoft: Access Tables and Relationships
-
IsNull and replace with "Text"
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...- senthilmuruganv
- Post #6
- Forum: Microsoft: Access Tables and Relationships
-
IsNull and replace with "Text"
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...- senthilmuruganv
- Post #3
- Forum: Microsoft: Access Tables and Relationships
-
IsNull and replace with "Text"
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...- senthilmuruganv
- Thread
- Replies: 7
- Forum: Microsoft: Access Tables and Relationships
