Get Value from query in a form unbound field without where condition

[hasanrazaj1]

hey dearz.

I have a query which includes 3 fields:

(1)- Sum of WithDrawalAmount
(2)- Sum of DepositAmount
(3)- BalanceAmount (Balance: [Sum Of Deposit Amount]-[Sum Of W/D Amount])



I have a bound Form including a unbound field name "GrandTotal"

I want to show query "BalanceAmount" value result in the Form GrandTotal field. how it is possible.

DLookup and ELookup funcations need the give where condition but i want to show the value without where condition.

 

[pbaldy]

You don't have to include the where portion of DLookup (the third argument). Without, it will simply return the first value it finds. Since your query only returns one value, that's fine.