Search results

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

i have query like this First Column accnum 111,112 ,113 , 121,122,123 Send Column Debit 700,500,0 200,900,100 Third Column Credit 400,200,0 100,800,600 _____________________________________________________________________________________ So Question is i need...

IF I do like you say it give me #size! instead of #type! in both cases when i Referesh report it will give Calculated amount ok with no Errors

Dears i have strange thing when i run report on access sometimes it will give calculated number and every thing is ok and sometimes it will give #Type! formula in Control source , Expression Builder i am Calculating 4 values from Text appear on report like this...

Thanks (y)

I have one row contains : Name | Debit | Credit Customer| 5500 | 2000 _____________________________________________________________________________________________________________________________________________ i want to make formula...

thanks it is perfect Appreciated