Search results

Hi, anyone can help me? i have a problem, do anyone know a queries to split the condition... in example select (a from t1 where t1.category = 'sell out'), (b from t1 where category = 'sell in') from t1? here is the screenshot of each table, first is [raw dealer] (contains...

Hi, could anyone help me please? currently i tried to make access report based on queries that i've been made. what i want in the report is i want to group the claim/no claim value based on channel/md/dealer record. for example the output, i tried attached it at the "hasil.png". so it group...

[SOLVED]Combine 2 queries in Access Hi, im newbie to access, my name is Ben, currently i have two syntax queries SELECT [Raw Dealer].CHANNEL, [Raw Dealer].MD, [Raw Dealer].DEALER, [Raw Dealer].MATERIAL, [Raw Dealer].IMEI, [Raw Dealer].[SOLD TO], [Export MCS].MODEL_CD, [Export...