Search results

or you could use select ([pay 1]+[pay 2]+[pay 3]+[pay 4]) as 'pay total',* from tablename

I tried to attach the relations of the table, the result of my query based on MD = "depo tam sby"...and i got the 83 records, each of them have duplicate IMEI result, but the duplicate is because the category, one imei has category sell in, sell out and production... what i want is i just took...

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, i tried your query but it produce the same, they count the null records, here i attach the output you produce, and what I want... if by your queries, it also count the field....the result are 15732 records, the right results must be 15282 :D :banghead::banghead::banghead:

neither do I :D i tried to export the data from the "testing" queries, and the result is like this. try to download the file, and count the claim and no claim column, you will see that the output is counting the blank column wheither it's contain data or no...

Hi Sneuberg, i've found the problem here, lately i tried copy the output of the query, the claim and no claim value is count even when they are null, but when i convert their data type in the excel, it count right, do you know how to convert the data type in the query? so when i call it on the...

currently the input date is defined by the user, if they input it today, then they just input 20151203 into the field. and after they input the date, i run the query so it automate compare the input date with sell date and produce "claim" or "no claim" but because im new to access, could you...

i didnt put them in the table, i just show them as a query, and the report i run it from my query. if the sell out date = input date, then the result is also claim, if the sell out date is NULL, then the result is also claim. did the problem is i dont put it on the table?

claim or no claims is determined when we input date, then i compared the sell out date and input date, if the sell out date > than input date, it produce claim and if sell out date < input date, it produce no claim from that report, i tried to count the claim and no claim value by each MD...

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...

im sorry bro for the miss of the raw data finally i got the clue and solve it..thank you for the helps :)

[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...