Recent content by Christykvlklm

  1. C

    Question MS Access repair_RECOVERY

    Dear Friends, Good Morning! One of my database "RFI" got repair/corrupted. File Not opening. Message - Microsoft database engine could not find the object. attached the comments Screen shot. Please anyone have recovery software please share. My database file size is 80mb.
  2. C

    Remove/Hide Duplicates from report/query

    Still Same. The Duplicate value in Single cell. Check attached image.
  3. C

    Remove/Hide Duplicates from report/query

    I have value in query in a column and single row "H103 PROD FRAC FEED HTR, H103 PROD FRAC FEED HTR, H103 PROD FRAC FEED HTR, H103 PROD FRAC FEED HTR, H103 PROD FRAC FEED HTR, H103 PROD FRAC FEED HTR, H103 PROD FRAC FEED HTR, H103 PROD FRAC FEED HTR". This value I concatenated from different rows...
  4. C

    Like a Cross tab Query out put required IN Query

    First - 005 Rej Second - 5R1 Rej Third - 5R2 Blank (Waiting for Result) - Last Result should Show "Rej" In this key is 3rd and 4th Column But my option is to create new key with WelderNo & PRNo and Search for Last Result.
  5. C

    Like a Cross tab Query out put required IN Query

    I uploaded the table. One record First result may "Rej" then again it will get "Acc". So the last result should show based on the RT Report date. Thanks Christy
  6. C

    Like a Cross tab Query out put required IN Query

    I made 10 query PR01, PR02, UP TO PR10. Then wrote Union Query. Then out put is if master table record is 50, union out put showing 500 records. I need out put if master is 50 then the value for PR01 up to PR10 Should display against each record of 50. (Column header PR01 UP RO PR10) refer...
  7. C

    Like a Cross tab Query out put required IN Query

    I made 10 query PR01, PR02, UP TO PR10. Then wrote Union Query. Then out put is if master table record is 50, union out put showing 500 records. I need out put if master is 50 then the value for PR01 up to PR10 Should display against each record of 50. (Column header PR01 UP RO PR10) refer...
  8. C

    Like a Cross tab Query out put required IN Query

    How the out put required I attached in pdf file. page2 Result from RTResult from master table (page1 in pdf)
  9. C

    Like a Cross tab Query out put required IN Query

    I have compiled some data from different table. Now I need the data as per attached. Welder | WelderName | PR01|PR02|PR03| UP TO PR10| having columns. Data..W000 | XXXXXXX|Acc|Acc| up to Column 10. Last result should show. If anyone can help us to resolve. Thanks Christy
  10. C

    Split text having comma in different column or rows

    This What I need. Data mismatching I will correct it. Thank you for your time with us. Again Thanking You, Christy
  11. C

    Split text having comma in different column or rows

    The query working, but output not what I expecting. Master table is "ztadefect". In that defect description having with comma need to be in separate columns or different rows with corresponding same row data. I attached the file. Thanking You. Christy
  12. C

    Split text having comma in different column or rows

    Thanks CJ for Immediate Reply. I have Separate table for Defect code. But the against the data that posted one record may have different defects, that user will update using comma. I attached defect code list what I have in separate table (tbldefectcode)
  13. C

    Split text having comma in different column or rows

    I want to split the text having comma in different rows or columns. This is my sample data. Table name "ztadefect" Code OrderNo DrawingNo JointNo WelderNo RTResult Defect I100000011930 20011937 P1287CMB-FG-114-3424-12 1 W093 Rej LOP,LF,EP I need data in below format, 1 2 3 4 5 6 7 Code...
See more
Back
Top Bottom