Search results

  1. M

    Combining multiple rows for same Id into one row

    You gave me an idea. What I did is just to add a condition to show result as 1 if the orgid exist in validity table and 0 if it's not there. Then I grouped it per Org ID and sum the fields. I added a condition statement that if the field is greater than 1 then it will display a Fail. Thanks a...
  2. M

    Combining multiple rows for same Id into one row

    Thank you. But How will I group the results? to show only "[blank" and Fail for each Org ID? sorry, I only know basics of Access.
  3. M

    Combining multiple rows for same Id into one row

    Hello, I just registered today... I have a similar problem. this is how my table looks like: Main Tbl Org ID CompanyName DateofInc 1234 ABC 1/24 1233 A Com...
  4. M

    combining the content from multiple rows into 1

    Hello, I just registered today... I have a similar problem. this is how my table looks like: Main Tbl Org ID CompanyName DateofInc 1234 ABC 1/24 1233 A Com 2/5 1444 TSY 3/53 ValidityTbl OrgID...
  5. M

    Hello

    Hi, I am currently assigned to do some macros and MS Access programs in our department. I'm still new and only know basics of VBA and MS Access. I appreciate if anyone would help me with some of the applications I am doing. I really like some posts in this site. It has helped me in some of my...
Back
Top Bottom