BAL BFWD

[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

 

[Marshall Barton]

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

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

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