Enter Parameter Value in Report

[lavanya]

I have a report that has a query for its record source.
The query is a simple one as follows :
SELECT TblSAIC_Total_Log.County,
TblSAIC_Total_Log.Book_Num,
TblSAIC_Total_Log.Total_Images,
TblSAIC_Total_Log.Total_Filesize,
TblSAIC_Total_Log.Date_Arrived
FROM TblSAIC_Total_Log;

Everytime I run this report it puts up this message box
Enter Parameter Value for 'Series' which is a field in
the table TblSAIC_Total_Log but not used in the query.
I have checked the Query Parameters and none are listed.
THe table does not have Series as a required value field
either . I am really baffled by this. Any help wold be
appreciated.

 

[John Viescas]

If the query runs OK by itself, then check the Sorting and Grouping settings
in your report. I bet there's a reference to Series in there. The report
won't prompt if you include Series in the SELECT clause of your query.

--
John Viescas, author
"Microsoft Office Access 2003 Inside Out"
"Running Microsoft Access 2000"
"SQL Queries for Mere Mortals"
http://www.viescas.com/
(Microsoft Access MVP since 1993)

 

[fredg]

I have a report that has a query for its record source.
The query is a simple one as follows :
SELECT TblSAIC_Total_Log.County,
TblSAIC_Total_Log.Book_Num,
TblSAIC_Total_Log.Total_Images,
TblSAIC_Total_Log.Total_Filesize,
TblSAIC_Total_Log.Date_Arrived
FROM TblSAIC_Total_Log;

Everytime I run this report it puts up this message box
Enter Parameter Value for 'Series' which is a field in
the table TblSAIC_Total_Log but not used in the query.
I have checked the Query Parameters and none are listed.
THe table does not have Series as a required value field
either . I am really baffled by this. Any help wold be
appreciated.

You probably had a field [Series] in your report which has since been
deleted, but the reference may still exist in a code sheet or another
control uses it in an expression.
The 'usual culprit' is the Sorting and Grouping dialog. Check to see
if you have a grouping on [Series].

 

[Guest]

That was exactly the problem. Thanku very much.

-----Original Message-----

I have a report that has a query for its record source.
The query is a simple one as follows :
SELECT TblSAIC_Total_Log.County,
TblSAIC_Total_Log.Book_Num,
TblSAIC_Total_Log.Total_Images,
TblSAIC_Total_Log.Total_Filesize,
TblSAIC_Total_Log.Date_Arrived
FROM TblSAIC_Total_Log;

Everytime I run this report it puts up this message box
Enter Parameter Value for 'Series' which is a field in
the table TblSAIC_Total_Log but not used in the query.
I have checked the Query Parameters and none are listed.
THe table does not have Series as a required value field
either . I am really baffled by this. Any help wold be
appreciated.

You probably had a field [Series] in your report which has since been
deleted, but the reference may still exist in a code sheet or another
control uses it in an expression.
The 'usual culprit' is the Sorting and Grouping dialog. Check to see
if you have a grouping on [Series].
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.
.