Recent content by mhakim

thanks for your reply forget about delete button do you have access database example how to make this

Drears good day i already have many forms i want to put them in one form or navigation form or i use form with Tab control at the end i want to make one save button for all forms one delete button for all forms one search button for all forms thanks in advance

it is done thanks for all of you

where i can run this query it give me message operation must use updateble query how can i use updateble query i already have normal union select query as PIC how do i run this SQL Statement to affect the query by new data

hi dears good day i am asking if i can if there is null on column (name_english) then the yellow data move from (Chart_Name_English) column to the Null column please look at PIC attached

I USE Query Design Criteria can i do the same in Criteria ??

Dears Good DAY i want to remove Yellow rows as PIC attached on another way i need Query whithout Yellow Rows

i am already doing this but may be there is a default option in report doesnot show dublicate YELLOW data in rows as PIC

i have query like PIC and report is not getting the same data 2 yello rows in Query result in 1 yello row in report

what is the insert query ?

hi dears good day please look at two PIC Attached i have Trialbalance Query show Total Account Transaction for all Pettycash Employees it is very good query i like it so the proplem here when i want the total account query to be in details by Employees like second PIC , It will...

i find the solution =Nz(DSum("[CreditPL]","IncomeStatement-T","Sequence2 Like '4*'"),0) -Nz(DSum("[DebitPL]","IncomeStatement-T","Sequence2 Like '5*'"),0)

So you say that i can not make any Expressions in reports on the query columns because all values on Reports are coming from queries i think there is a solution that we donot have

Attached Design and also final view

Thanks for your effort really appreciated =Nz(Sum([IncomeStatement-T]![CreditPL]-[IncomeStatement-T]![DebitPL])) I PUT THIS GIVE ME Error [IncomeStatement-T] is the Query contain the two columns [CreditPL] and [DebitPL]