Enter Parameter Value keeps appearing

[Haji]

Hi,

I have a table called Transactions with fields such as
Date, Name, Item, Customer, QTY and Total. I wrote two
queries. The first filtered out all non-2005 items
sales. The second summed the item totals. I am doing a
report that lists Item, SumOfQty and SumOfAmount. The
problem is that when I run this report, it keeps
saying "Enter Paramter Value Transactions.Name". The
problem is that Name is not in either of my queries or my
report. I tried recreating my queries and sorting them
by different fields but I can get rid of this parameter
value. It simply should not appear since this field is
not a part of my queries or report but I can't seem to
get rid of if. Can anyone help?

Thanks,

Chuck

 

[fredg]

Hi,

I have a table called Transactions with fields such as
Date, Name, Item, Customer, QTY and Total. I wrote two
queries. The first filtered out all non-2005 items
sales. The second summed the item totals. I am doing a
report that lists Item, SumOfQty and SumOfAmount. The
problem is that when I run this report, it keeps
saying "Enter Paramter Value Transactions.Name". The
problem is that Name is not in either of my queries or my
report. I tried recreating my queries and sorting them
by different fields but I can get rid of this parameter
value. It simply should not appear since this field is
not a part of my queries or report but I can't seem to
get rid of if. Can anyone help?

Thanks,

Chuck

1) The prompt may be coming from the report, not the query.
In all probability you have a reference remaining to a field in the
report that has since been deleted.
The usual culprit is the report's Sorting and Grouping dialog....
View + Sorting and Grouping.

2) Do you really have fields named "Date" and "Name"?

'Name' and 'Date' are reserved Access/VBA/Jet words and should not be
used as field names.
See the Microsoft KnowledgeBase article for your version of Access:

109312 'Reserved Words in Microsoft Access' for Access 97
209187 'ACC2000: Reserved Words in Microsoft Access'
286335 'ACC2002: Reserved Words in Microsoft Access'
321266 'ACC2002: Microsoft Jet 4.0 Reserved Words'