How do I change query field to prevent "Enter parameter value"?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello! When I do a query with totals, where I have "Field1" as a group by
and then "Field1" as a COUNT, I end up getting an "Enter Parameter Value"
when I run the query. It says its because of the Field name, which has been
changed to "CountOfField1". How does one set up a query where you have a
count in it, without getting the "Enter Parameter Value" dialog box?
 
I don't know why you would be getting this message, but you could give the
Count(Field1) an alias by preceding it with Count:Field1 or Total:Field1 or
even Count:Count(*) and change the Total line to Expression. If you are
reference the counted field in a report, use the alias instead of the field
name. That's only reason I can think of you would be getting the message.

Paul Hammond
Richmond, VA
 
This is odd. What do you have to enter in response to the prompt?

Post your SQL statement. Open the query in design view and click on menu
VIEW - SQL View. Highlight, copy, and paste in a post.
 
Back
Top