aaa

Working with databases is new to me so thank you for any assistance you can provide. I have a database where data is stored as follows: Table: Rates <tbody> Company<o:p></o:p> Item<o:p></o:p> Labor Rate<o:p></o:p> Matl Rate<o:p></o:p> AAA<o:p></o:p>...

<colgroup><col style="mso-width-source:userset;mso-width-alt:1974;width:41pt" width="54"> <col style="mso-width-source:userset;mso-width-alt:4315;width:89pt" width="118"> <col style="width:48pt" width="64"> </colgroup><tbody> 2017-06 AAA 163386 2017-07 AAA 12807...

Hi Everyone, I'm trying to figure out a vlookup that will display the first result & in the next cell, display the 2nd result, etc On One sheet (tab), There can be multiple rows of the same Employee ID & Customer Name. What I'm trying to do is on the "Employee" sheet (tab) is bring back only...

hi all... i have table layout ... how to replace/remove after mark parenthesis (....) Excel 2007 32 bit DE 4dataafter formula 5text (aaaa aaa bbbbb)text 6text (aaa bbb cccccccccc)text 7text (aa ddd eeeeeeeeeeeeee)text Sheet: Sheet1 any assistance...much appreciated.. m.susanto

i am using the formula for count if =COUNTIF(A$2:$A2,A2) but it is displaying number for result can it be alphabet <tbody> DATA COUNTIF REQUIRED AAA 1 A AAA 2 B AAA 3 C AAA 4 D AAA 5 E BBB 1 A BBB 2 B BBB 3 C BBB 4 D CCCC 1 A CCCC 2 B CCCC 3 C </tbody>

Hi, I have two tables: one with all items from a ERP-system (2), and one with manual correction to the items lists product hierachy (1). The manual corrections (1) can hold items which also will be found in the item list table (2). The two tables are joined in an UNION query. My problem is...

I have the table1 below and want to make a table that shows how many friends Ent1 has in common with any other person from Ent1. Eg A (short for AAA) has friends B,C,D,E,F while B has friends A,C,E,F. They have C,E,F in common so the outcome should be AAA BBB 3 Can this be done in acces/SQL? I...