Recent content by Machlink

I did added extents still Iam getting same error. Thanks

I'm getting ORA-01652 unable to extend the temp segmentby 16 in tablespace temp01 Thanks in advance

I did no use it increase the logical read Thanks

SELECT od.patient_sys, od.visit_sys, CONVERT(NVARCHAR, p.dob, 101), p.name_last + ', ' + p.name_first, p.reg_num, COUNT(od.patient_sys), (CASE WHEN DATEDIFF(MM, p.dob, GETDATE())/12 >= 2 AND...

I have a activity field which consists of administration, protection, support records. I want to display administration record as admin in my tblrequest. How to do this? Thanks in advance

Hi Leslie! I have made those changes still If I one pick animals in one combo box it is not filter in second combo box. what I need was suppose if user picks animals in cbocause it should bring all the animals codes in second cboprotect. Thanks in advance

I have need to limit selection available in a combox based on another combo box If Not IsNull(Me!cboProtect) Then Me!cboProtect.RowSource = "SELECT tblProtect.ID, tblProtect.Description" _ & " FROM (tblProtect Left Outer JOIN tblCauselookup ON...

I have want to count no of DP,St,pm in mpitems.no field. Any formula help would be appreciated. Thanks in advance

I have a Mpitems.no consists of DP,ST,PM records. I want count no of DP in mpitems.no field which is grouped by mpitems.no field. Thanks in advance

I have following query to update tbl materail UPDATE Material RIGHT JOIN Engcost ON Material.[PART NO]=Engcost.[PART NO] SET Engcost.[PART NO] = Material.[PART NO], Engcost.[MATERIAL DESCRIPTION] = Material.[MATERIAL DESCRIPTION], Engcost.[COST EACH] = Material.[COST EACH], Engcost.CD =...

Thank you for your note PHV. Can you explained me steps by steps process how to do this?

I have a combo box cause based on tbl causelookup which consists of ID, Description and code fields on form outage. I have another combo box field protect based on tblprotect which conists of ID, description and code fields. I need limit selection of values of combo protect based on selection in...

I need to have carriage return in @combine_nn field which is 80 characters i need at 81 character. How to do this . Thanks in advance

How to get new page after each sort record. Iam sorting by N and Y records. I need to get new page after N records. Thanks in advance

Iam getting error in where clause near As can someone fix for me this statement