Recent content by mdmatiullah

  1. M

    Select Query

    Hi, I have dept no separated with comma in a string str1 and a table of deptno Table named as 'dept' and field as deptno .I want to search the string str1 in table dept and get the deptno that does n't exist in table dept . Thanks Md.Matiullah
  2. M

    Update query with Select statement

    Table PR has multiple records on same primary key P.I .I want to update P.HMD with count of PR.I on specified condition . I am getting this error. Operation must be an updatable query. Access query is given below. UPDATE P INNER JOIN PR ON P.I=PR.I SET P.HMD = (SELECT COUNT(PR.I) FROM PR WHERE...
  3. M

    How to make this query more efficient?

    1. Indexing is required 2. Query is too slow because of linked table 'tbl_questionnair' in Access database, You should make a connection with Sql server instead of making a linked table. I have faced this type of problem in linking DB2 table with access database. Mati
  4. M

    Auto Email Problem

    Hi try to remove space and make a string in email addresses. vba.Str(vba.trim(Forms!frmRaise_Revision1.cboSupplierEmail)) & "; " vba.cstr(vba.trim(Forms!frmRaise_Revision1.cboSupplierEmail))
  5. M

    Update query with Inner join

    Yes whse_type and store_nbr are indexed.
  6. M

    Update query with Inner join

    Hi, I have two tables named DOH1 and Alignment , want to update DOH1.whse_nbr based on condition DOH1.STORE_NBR=ALIGNMENT.STORE_NBR AND DOH1.WHSE_TYPE=ALIGNMENT.WHSE_TYPE I am writing this query using Inner join UPDATE DOH1 INNER JOIN ALIGNMENT ON (DOH1.STORE_NBR=ALIGNMENT.STORE_NBR AND...
See more
Back
Top Bottom