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

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?
 
G

Guest

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
 
G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Parameter Value in Crosstab Query 4
Parameter Value Entry 5
Update Query: Enter Parameter Value 2
Enter parameter value Query1. ... 3
Query Parameter using multiple options 0
ACCESS - how do I apply a IIF = statement without parameter value prompt. The two column comparison is count 1
"inter parameter value" 3
Parameter Query with DSum 1

Top