Recent content by mhakim

  1. M

    many forms one (save or delete) button for all

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

    many forms one (save or delete) button for all

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

    Solved query data shift or move from clolumn to other

    it is done thanks for all of you
  4. M

    Solved query data shift or move from clolumn to other

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

    Solved query data shift or move from clolumn to other

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

    Query Filter

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

    Query Filter

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

    Solved report not like query

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

    Solved report not like query

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

    Solved query repeating rows

    what is the insert query ?
  11. M

    Solved query repeating rows

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

    Solved Expression text formula

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

    Solved Expression text formula

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

    Solved Expression text formula

    Attached Design and also final view
  15. M

    Solved Expression text formula

    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]
Top Bottom