report expression builder

[mark kubicki]

I am building an expression for a field in a report using the SQL editor
(...); unfortunately, the expression is long and complicated enough
(multiple IIF's and Dlookup's); and it does not seem possible to use
indents... in this view;

is there a workaround...?
(trying to keep track of "("'s and ")"'s is driving me crazy

thanks in advance,
mark

 

[Marshall Barton]

I am building an expression for a field in a report using the SQL editor
(...); unfortunately, the expression is long and complicated enough
(multiple IIF's and Dlookup's); and it does not seem possible to use
indents... in this view;

is there a workaround...?
(trying to keep track of "("'s and ")"'s is driving me crazy

Well, you could copy/paste the sql into Notepad, edit it
there and the copy/paste it back. Probably better for Jet
tables would be to create a public function in a standard
module so you can use multple lines of VBA code instead of
mashing it all into single expression.

If your query's dataset is even moderately large, you'll be
able to measure the query's performance with an hourglass.

You might be better off doing the calculation in the report
(after the dataset has been filtered).

If possible, you should try to figure out a way to Join the
query's table to the DLookup's table so the DLookup values
are available without going off to another table on every
record.