Unrecognised table field in report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi all,

I am trying to create a simple report. My current problem is that if I try
altering an existing report by simply adding a field name to the list of
fields in the 'SELECT...' statement, when I preview the report it requests
the value of the added field. I have checked the spelling etc etc. I have
also tried adding it from a query, where the query was built by double
clicking fields in table field lists.

If I try to create a brand new report it says 'subscript our of range'

the original report has the record source as:
SELECT person.[PERSON ID], person.AKAPID, SEARCHES.date, SEARCHES.type,
SEARCHES.amount

FROM person INNER JOIN SEARCHES ON person.[PERSON ID] = SEARCHES.[PERSON ID]

WHERE (((person.[PERSON ID])=[Forms]![person]![PID])) OR
(((person.AKAPID)=[forms]![person]![exakapid])) OR
(((person.AKAPID)=[forms]![person]![akapid]))

ORDER BY SEARCHES.date DESC;


All I want to do is restrict the report to only display values when a
certain condition is true, that condition being that SEARCHES.[CLIENT ID] is
equal to a particular value.

When I add this field to the report it all goes pearshaped.

Any help before I've pulled all my hair out is much appreciated.
 
Are you saying that adding the selection criterion to a query in design mode
does NOT work?

Have you tried starting over from scratch?

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Yup - it doesn't work, just because I add an 'and xxx.xxx=yyy.yyy' into the
where statement.

I did try starting from scratch. It didn't work.

Fortunately the problem is now solved. Some helpful person advised me to
create a 'make table' query and get the report to refer to that. Referring to
non-make table queries did not work, but his solution has worked.

Thanks for your interest

Jeff Boyce said:
Are you saying that adding the selection criterion to a query in design mode
does NOT work?

Have you tried starting over from scratch?

Regards

Jeff Boyce
Microsoft Office/Access MVP


inbreda said:
Hi all,

I am trying to create a simple report. My current problem is that if I try
altering an existing report by simply adding a field name to the list of
fields in the 'SELECT...' statement, when I preview the report it requests
the value of the added field. I have checked the spelling etc etc. I have
also tried adding it from a query, where the query was built by double
clicking fields in table field lists.

If I try to create a brand new report it says 'subscript our of range'

the original report has the record source as:
SELECT person.[PERSON ID], person.AKAPID, SEARCHES.date, SEARCHES.type,
SEARCHES.amount

FROM person INNER JOIN SEARCHES ON person.[PERSON ID] = SEARCHES.[PERSON
ID]

WHERE (((person.[PERSON ID])=[Forms]![person]![PID])) OR
(((person.AKAPID)=[forms]![person]![exakapid])) OR
(((person.AKAPID)=[forms]![person]![akapid]))

ORDER BY SEARCHES.date DESC;


All I want to do is restrict the report to only display values when a
certain condition is true, that condition being that SEARCHES.[CLIENT ID]
is
equal to a particular value.

When I add this field to the report it all goes pearshaped.

Any help before I've pulled all my hair out is much appreciated.
 
Back
Top