sls

I have a code module that calculates monthly commission values. Some of the salesmen have shared accounts where 2 salesmen service a common account. In the database this is indicated by the SLS code (Column B) having 2 salesmen's initials separated by "/". When this happens each salesman...

Hello Everyone, First time poster, the following query works just fine in access: However, when I try to connect it to VBA it doesn't work: I get a runtime error '2147217887 (80040e21)': Automation Error Code and query below Select a.str, a.name, b.dpt, c.desc, sum(b.[Sales TY]) AS...

Hello Everyone, First time poster, the following query works just fine in access: However, when I try to connect it to VBA it doesn't work: I get a runtime error '2147217887 (80040e21)': Automation Error Code and query below Select a.str, a.name, b.dpt, c.desc, sum(b.[Sales TY]) AS [Sales...

Hi all, I need to transform/ re-arrange data in Access. Below table illustrates the data that I currently have: <tbody> Year FY18 FY18 FY18 FY18 Month MAR MAR FEB FEB Country Channel Brand Item Number SLS UNT SLS CST SLS UNT SLS CST China RLS MSW 10004 34 $87.00 56 $80.00...