Unrecognised table field in report

[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.

 

[Jeff Boyce]

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

 

[Guest]

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

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

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.