Search results

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]

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

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

thanks Appreciated

thanks for reply i am so grateful Syntax error appear

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