Recent content by okotan

Mr. cj, Please see attached. You can see name of column expr1 in the CH_HAREKET_1 query

Mr CJ first of all thanks for your quick response. The query is runing when use "Clng" and runing sum by date. But this function doesnt work if i want to use three parameter for example; Criterias 1- Account number (CH_ID) 2- Curreny (DOVIZ) 3- Movement date (TARIH)...

Hello all i want to create runingsum query by date. But getting error in query Script : TARIH_Q: DSum("DOVIZ_BORC";"CH_HAREKET";"TARIH>#" & [TARIH] & "#") The query show #ERROR i need your urgent support thanks

Hello all how can i disable ctrl + f key by vba thanks

problem was solved when i remove val() function. thank you very much

Hello all i want to get numerical value from table by dlast function to query But the number is 870,04 in the table however the number is 870,00 in the query i didnt understand, why couldnt get ,04 value to query The Function as below; Val(IIf([Period]=0 Or...

i use ONCEKI_VADE: DLookUp("[ODEME_TARIHI]";"ODEME_PLANI";"[ID]=" & [ID]-1 & " and [HESAP_KODU]='" & [HESAP_KODU] & "'") script in query the program giving #ERROR when i click the run button whats wrong ?

hello all i am using ms access 2013 and how to compare different date row according to account code in access such as account code due date interest 1 15/01/2015 300.000 1 16/02/2015 500.000 2...

thanks for your interest but i have solved that issues. i should be [] symbol for parameters

dear all i couldnt open web link by vba. Could you please asist on this issue Application.FollowHyperlink "//xxxxxx/ReportServer/Pages/ReportViewer.aspx?/xxxxx/RPT_CTB_Extratos_Contas&data_ini="& BAST_YIL & BAST_AY & BAST_GUN " data_fim=" & BITT_YIL & BITT_AY & BITT_GUN"ano="& YIL"...

great, code worked thanks for your support

dear all i getting error "THE EXPRESSİON YOU ENTERED İS MİSSİNG A CLOSİNG PARANTHESİS BRACKET OR VERTİCAL BAR" when using iif function as below IIf([SATIS_YILI]>[Forms]![RAPOR].[AMORT_YIL] And [SATIS]="Evet";"Hayır" And (IsNull([SATIS_YILI]);"Hayır"...

Thanks For Your Quİck Support

dear all ı would like to calculate moving weighted avarage cost for inventory application how to calculate method for query or report please support thanks

Hİ How To Calculate Movİng Weİght Avarage Cost İn Report Or Modul Etc. Thanks For Your Support