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