D
Derek
In defining the control source of a textbox in a report,
can I use a SQL statement to select certain field from a
table with conditions? If yes, would anyone please to tell
the exact grammar? I am having trouble in composing the
SQL statement in expression builder.
Thanks a lot!
Actually, I am trying to build a report based on one
single table. But some fields in the report need data from
the table under different condition. For example, i have
need a textbox show expense for year 2003, and the other
textbox show expense for year 2002. In the table, these
would be two records. So i am trying to build the record
source of the report for year 2003, and use control source
of specific fields to retrieve data for year 2002. not
sure i can do it in this way or not. Thanks a lot!
can I use a SQL statement to select certain field from a
table with conditions? If yes, would anyone please to tell
the exact grammar? I am having trouble in composing the
SQL statement in expression builder.
Thanks a lot!
Actually, I am trying to build a report based on one
single table. But some fields in the report need data from
the table under different condition. For example, i have
need a textbox show expense for year 2003, and the other
textbox show expense for year 2002. In the table, these
would be two records. So i am trying to build the record
source of the report for year 2003, and use control source
of specific fields to retrieve data for year 2002. not
sure i can do it in this way or not. Thanks a lot!