BAL BFWD

  • Thread starter Thread starter Deron
  • Start date Start date
D

Deron

hOW DO I GET A REPORT OF TRANSACTIONS TO SHOW BROUGHT FWD BALANCES I.E WHEN I
SELECT THE DATE RANGE I WANT TO SEE TOTAL AMOUNT FOR DATES BEFORE THE BEGIN
DATE AS A BAL BFWD ONE LINE:-0
 
Deron said:
hOW DO I GET A REPORT OF TRANSACTIONS TO SHOW BROUGHT FWD BALANCES I.E WHEN I
SELECT THE DATE RANGE I WANT TO SEE TOTAL AMOUNT FOR DATES BEFORE THE BEGIN
DATE AS A BAL BFWD ONE LINE:-0
Click to expand...


That's difficult to read, please fix your Caps Lock key.

Try using:
DSum("balance", "table", "datefield < " & Format(startdate,
"\#yyyy-,-d\#")
 
Back
Top