#error and #name?

From: confused (confused_at_discussions.microsoft.com)
Date: 09/13/04 

Date: Sun, 12 Sep 2004 23:45:01 -0700

Hiya
I am getting #error and #name? errors on my report. If anyone could help me
out with either of these I would really appreciate it. Details are below

Thanks very much for your help!

#error
the report is linked to a query, and contains text fields to display each
row of the query,
eg Controlname = TxtSoftware, CountrolSource: Software (the field in the
query) At the bottom I have a "totals" row:
ControlSource = Sum([Software])
I have also tried ControlSource = sum([TxtSoftware]) but in both cases I get
#error displayed!

#name?
The report is linked to a query, but I want a field that does a count of
rows from a different table. so, control source = Select count(*) from tbl1
where Software = 5.
However i get a 3name? error!!

Im very confused!

Relevant Pages

  • Re: #error and #name?
    ... Also, make sure the sum is in the a group or report footer, not the Page ... > the report is linked to a query, and contains text fields to display each ... > I have also tried ControlSource = sumbut in both cases I ...
    (microsoft.public.access.reports)
  • Re: Limiting Decimal Places in Report
    ... it seems to me the problem is that the query ... you might be able to force the report to interpret ... if the query field is named Field1, the ControlSource of the text box would ... I can't begin count the number of queries that would need updating. ...
    (microsoft.public.access.reports)
  • Re: Unwanted Parameters Show Up ina Report
    ... Allen Browne - Microsoft MVP. ... query you think it is. ... it must be the Name or part of the ControlSource ... I had an old report wherein I changed the source and developed a new ...
    (microsoft.public.access.reports)
  • Re: Unwanted Parameters Show Up ina Report
    ... query you think it is. ... it must be the Name or part of the ControlSource of ... Tips for Access users - http://allenbrowne.com/tips.html ... I had an old report wherein I changed the source and developed a new ...
    (microsoft.public.access.reports)
  • Re: Start Report Numbering at 4
    ... What is the ControlSource for the control that displays the line numbers? ... numbering at 1 when the source =1, I need it to start numbering at 4. ... All the other cells except for total come off a query, ... numbering is automatic with the report. ...
    (microsoft.public.access.modulesdaovba)