Re: Calculations on report...

Tech-Archive recommends: Fix windows errors by optimizing your registry

Duane:
Why would you need to see all the fields on the report? There are a few other
fields that have no connection to the calculation at all. What I gave you is
what is needed. The fields on the report would be rpt_***_*******.

As for the frm_cmb_Province, thats is a combo box on the form which is
connected to a table. The field name in the table is Province. Form name is
frm_cmb_Province.

NEWF

Duane Hookom wrote:
You don't seem to be understanding what I am asking. When you look at the
Field List while in the report design view, what fields do you see?

Forms display values from tables/queries. I am confused regarding:
"frm_cmb_Province is a field that is bound to a table on the form"
Does this mean you have a table with a field named "frm_cmb_Province"? Or,
do you have a field named "Province" in a table?

Duane:
They are the same. No field named FORM. As for the names frm_txt would
[quoted text clipped - 21 lines]
Newf
~Everyone needs a NEWFIE as a friend~

--
Newf
~Everyone needs a NEWFIE as a friend~

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-reports/200608/1

.

Relevant Pages

  • Re: Calculations on report...
    ... Here is the if statement I need to place on the report either in the on ... Duane Hookom wrote: ... ~Everyone needs a NEWFIE as a friend~ ...
    (microsoft.public.access.reports)
  • Re: Calculations on report...
    ... REAL NEWBIE with calculations. ... is a report problem because I need the calcultions to be shown on the report ... ~Everyone needs a NEWFIE as a friend~ ...
    (microsoft.public.access.reports)
  • Re: Calculations on report...
    ... so if I view the field list of your report I will see fields named ... fields that have no connection to the calculation at all. ... ~Everyone needs a NEWFIE as a friend~ ...
    (microsoft.public.access.reports)
  • Re: Calculations on report...
    ... Yes to the text box question being used on the report. ... You can use IIfin a control source like: ... ~Everyone needs a NEWFIE as a friend~ ...
    (microsoft.public.access.reports)
  • Re: Frustration and Excitement with Crystal Reports
    ... data in it to report on. ... 'you may have to fool with the right hand side to get the right connection - ... Right click on the Database Fields. ... Select "Set Datasource Location". ...
    (microsoft.public.dotnet.languages.vb)