Search results

  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]
  16. M

    Solved Expression text formula

    i am so grateful for what you do thanks alot but i need the only expression final result = sum CreditPL Column - Sum DebitPL Column = 1,108,530.52 - 461,769.16 will appear finally 646,761 in text box how to get NZ(SUMCreditPL)-NZ(SUMDebitPL) BUT it does not work
  17. M

    Solved Expression text formula

    i have query as PIC Attached i need to put Expression in report text to allow me to get one value = sum CreditPL Column - Sum DebitPL Column = 1,108,530.52 - 461,769.16 will appear finally 646,761
  18. M

    Solved filter query column by another Column

    thanks Appreciated
  19. M

    Solved filter query column by another Column

    thanks for reply i am so grateful Syntax error appear
  20. M

    Solved filter query column by another Column

    please take a look this is query in view mode i just want to add more 2 two colums as above (Filter more data on query ) please take a look this is query in view mode i just want to (Filter more data on query ) add more 2 two colums as PIC Attached
Top Bottom