Unrecognised table field in report inbreda 13.09.2006 12:45:02 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.

Re: Unrecognised table field in report "Jeff Boyce" <nonsense[ at ]nonsense.com> 13.09.2006 14:32:57 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" <inbreda[ at ]discussions.microsoft.com> wrote in message news:C58E1B6C-75A6-421E-BA59-0192551A2357[ at ]microsoft.com... [Quoted Text] > 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. >

Re: Unrecognised table field in report inbreda 14.09.2006 14:17:02 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" wrote: [Quoted Text] > 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" <inbreda[ at ]discussions.microsoft.com> wrote in message > news:C58E1B6C-75A6-421E-BA59-0192551A2357[ at ]microsoft.com... > > 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. > > > > >