Expressions/formula in Access report

[Newbie101]

I have a report that run off a summary query. That will be my monthly month
end report, but i want to also put in the amount in the GL (which will have
to change monthly) and a variance field on this report. What's the best way
to do that? I also do not know how to build an expression for reports.
Please help! Thanks!

 

[John W. Vinson]

I have a report that run off a summary query. That will be my monthly month
end report, but i want to also put in the amount in the GL (which will have
to change monthly) and a variance field on this report. What's the best way
to do that? I also do not know how to build an expression for reports.
Please help! Thanks!

Please help *us*. We have no way to know where the GL (General Ledger I'm
guessing??) information is stored, nor anything about your table structure,
nor how your calculations are to be done. You can see your database... we
cannot.

You can put calculated expressions in the Query upon which the report is
based, or put an expression like

=[ThisField] - [ThatField]

in the Control Source of a report textbox, if you just want to display the
result of that expression.

 

[Newbie101]

Sorry for not having enough information.

The GL is not store anywhere in the Access. I was planning on just typing
it in somewhere in the report and just do a quick calculation.

I have a report that run off a summary query. That will be my monthly month
end report, but i want to also put in the amount in the GL (which will have
to change monthly) and a variance field on this report. What's the best way
to do that? I also do not know how to build an expression for reports.
Please help! Thanks!

Please help *us*. We have no way to know where the GL (General Ledger I'm
guessing??) information is stored, nor anything about your table structure,
nor how your calculations are to be done. You can see your database... we
cannot.

You can put calculated expressions in the Query upon which the report is
based, or put an expression like

=[ThisField] - [ThatField]

in the Control Source of a report textbox, if you just want to display the
result of that expression.

 

[John W. Vinson]

Sorry for not having enough information.

The GL is not store anywhere in the Access. I was planning on just typing
it in somewhere in the report and just do a quick calculation.

You cannot type into a Report - reports are output-only (maybe that's changed
in 2007 but I doubt it).

What you can do is use a Form with a textbox; on the report or in an
expression in the report's recordsource query you can refer to

=Forms![NameOfForm]![NameOfTextbox]

to pull the value from the form.