Access 2003 report in access 2007
in [Reports]
|
From: Peter on 15 Oct 2009 11:25 Hullo, I created a report in Access 2003 based on a query which is based on one table. It works perfectly in Access 2003 however it will not open in Access 2007. The query it is based on runs ok in Access 2007 though. When I try to open the report I get an error message: " Is not a valid name. Make sure that it does not include invalid characters or punctuation and that it is not too long. I cannot find a name of a field in the table that defies these rules. The names of the report and the query do not defy these rules either. If you could help me I would be greatful. -- Aussie
From: KARL DEWEY on 15 Oct 2009 18:10 Post the SQL of your query. -- Build a little, test a little. "Peter" wrote: > Hullo, > > I created a report in Access 2003 based on a query which is based on one > table. It works perfectly in Access 2003 however it will not open in Access > 2007. The query it is based on runs ok in Access 2007 though. > > When I try to open the report I get an error message: " Is not a valid name. > Make sure that it does not include invalid characters or punctuation and that > it is not too long. > > I cannot find a name of a field in the table that defies these rules. The > names of the report and the query do not defy these rules either. > > If you could help me I would be greatful. > > -- > Aussie
From: Peter on 15 Oct 2009 19:43 Dear Karl, Here is the SQL of the Query. Thanks SELECT [Vegetation Tracking].[Record No], [Vegetation Tracking].[Job Code], [Vegetation Tracking].Tenure, [Vegetation Tracking].[RE Maps], [Vegetation Tracking].[RE Data], [Vegetation Tracking].[CSEP Data], [Vegetation Tracking].[CSEP Data received], [Vegetation Tracking].[KML created], [Vegetation Tracking].[Forms sent], [Vegetation Tracking].Phoned, [Vegetation Tracking].[Disclaimer received], [Vegetation Tracking].[Client response], [Vegetation Tracking].[PMAV lodged], [Vegetation Tracking].[PMAV expected], [Vegetation Tracking].[Confirmation of Receipt], [Vegetation Tracking].[Draft offer], [Vegetation Tracking].[Draft offer accepted], [Vegetation Tracking].[PMAV Certificate], [Vegetation Tracking].[Shape files], [Vegetation Tracking].Notes, [Vegetation Tracking].[Job finished] FROM [Vegetation Tracking] WHERE ((([Vegetation Tracking].[Job finished])=No)) ORDER BY [Vegetation Tracking].[Job Code]; -- Aussie "KARL DEWEY" wrote: > Post the SQL of your query. > -- > Build a little, test a little. > > > "Peter" wrote: > > > Hullo, > > > > I created a report in Access 2003 based on a query which is based on one > > table. It works perfectly in Access 2003 however it will not open in Access > > 2007. The query it is based on runs ok in Access 2007 though. > > > > When I try to open the report I get an error message: " Is not a valid name. > > Make sure that it does not include invalid characters or punctuation and that > > it is not too long. > > > > I cannot find a name of a field in the table that defies these rules. The > > names of the report and the query do not defy these rules either. > > > > If you could help me I would be greatful. > > > > -- > > Aussie
From: Duane Hookom on 16 Oct 2009 11:21 If [Job Finished] is a yes/no field, try replacing No in the criteria with 0. A yes/no field actually stores 0 for No/False and -1 for Yes/True. -- Duane Hookom Microsoft Access MVP "Peter" wrote: > Dear Karl, > > Here is the SQL of the Query. > > Thanks > > SELECT [Vegetation Tracking].[Record No], [Vegetation Tracking].[Job Code], > [Vegetation Tracking].Tenure, [Vegetation Tracking].[RE Maps], [Vegetation > Tracking].[RE Data], [Vegetation Tracking].[CSEP Data], [Vegetation > Tracking].[CSEP Data received], [Vegetation Tracking].[KML created], > [Vegetation Tracking].[Forms sent], [Vegetation Tracking].Phoned, [Vegetation > Tracking].[Disclaimer received], [Vegetation Tracking].[Client response], > [Vegetation Tracking].[PMAV lodged], [Vegetation Tracking].[PMAV expected], > [Vegetation Tracking].[Confirmation of Receipt], [Vegetation Tracking].[Draft > offer], [Vegetation Tracking].[Draft offer accepted], [Vegetation > Tracking].[PMAV Certificate], [Vegetation Tracking].[Shape files], > [Vegetation Tracking].Notes, [Vegetation Tracking].[Job finished] > FROM [Vegetation Tracking] > WHERE ((([Vegetation Tracking].[Job finished])=No)) > ORDER BY [Vegetation Tracking].[Job Code]; > > -- > Aussie > > > "KARL DEWEY" wrote: > > > Post the SQL of your query. > > -- > > Build a little, test a little. > > > > > > "Peter" wrote: > > > > > Hullo, > > > > > > I created a report in Access 2003 based on a query which is based on one > > > table. It works perfectly in Access 2003 however it will not open in Access > > > 2007. The query it is based on runs ok in Access 2007 though. > > > > > > When I try to open the report I get an error message: " Is not a valid name. > > > Make sure that it does not include invalid characters or punctuation and that > > > it is not too long. > > > > > > I cannot find a name of a field in the table that defies these rules. The > > > names of the report and the query do not defy these rules either. > > > > > > If you could help me I would be greatful. > > > > > > -- > > > Aussie
From: Peter on 19 Oct 2009 00:28
Dear Duane, Sorry for being so long in repluying. I tried that but it made no difference. Thanks -- Aussie "Duane Hookom" wrote: > If [Job Finished] is a yes/no field, try replacing No in the criteria with 0. > A yes/no field actually stores 0 for No/False and -1 for Yes/True. > > -- > Duane Hookom > Microsoft Access MVP > > > "Peter" wrote: > > > Dear Karl, > > > > Here is the SQL of the Query. > > > > Thanks > > > > SELECT [Vegetation Tracking].[Record No], [Vegetation Tracking].[Job Code], > > [Vegetation Tracking].Tenure, [Vegetation Tracking].[RE Maps], [Vegetation > > Tracking].[RE Data], [Vegetation Tracking].[CSEP Data], [Vegetation > > Tracking].[CSEP Data received], [Vegetation Tracking].[KML created], > > [Vegetation Tracking].[Forms sent], [Vegetation Tracking].Phoned, [Vegetation > > Tracking].[Disclaimer received], [Vegetation Tracking].[Client response], > > [Vegetation Tracking].[PMAV lodged], [Vegetation Tracking].[PMAV expected], > > [Vegetation Tracking].[Confirmation of Receipt], [Vegetation Tracking].[Draft > > offer], [Vegetation Tracking].[Draft offer accepted], [Vegetation > > Tracking].[PMAV Certificate], [Vegetation Tracking].[Shape files], > > [Vegetation Tracking].Notes, [Vegetation Tracking].[Job finished] > > FROM [Vegetation Tracking] > > WHERE ((([Vegetation Tracking].[Job finished])=No)) > > ORDER BY [Vegetation Tracking].[Job Code]; > > > > -- > > Aussie > > > > > > "KARL DEWEY" wrote: > > > > > Post the SQL of your query. > > > -- > > > Build a little, test a little. > > > > > > > > > "Peter" wrote: > > > > > > > Hullo, > > > > > > > > I created a report in Access 2003 based on a query which is based on one > > > > table. It works perfectly in Access 2003 however it will not open in Access > > > > 2007. The query it is based on runs ok in Access 2007 though. > > > > > > > > When I try to open the report I get an error message: " Is not a valid name. > > > > Make sure that it does not include invalid characters or punctuation and that > > > > it is not too long. > > > > > > > > I cannot find a name of a field in the table that defies these rules. The > > > > names of the report and the query do not defy these rules either. > > > > > > > > If you could help me I would be greatful. > > > > > > > > -- > > > > Aussie |