Filtering Based on Count.

[yeppy12]

I have 4 columns in my table called Ovens: Last_Name, Age, City, and Clerk. First, I want to count the last names and sum them by clerk. Second, I want to filter based on a number I type (i.e., if I want to see the clerks with sums greater than 24, I only want the query to display sums of 25 and up. Can this be done in one query? If so, how can I go about this?

 

[khawar]

Is this clerk a numeric field if no how do you want to sum

 

[khawar]

Check query1 is this what you want

 

[yeppy12]

Is this clerk a numeric field if no how do you want to sum

No, the clerk field is a text field.

 

[yeppy12]

No, the clerk field is a text field.

Ideally, if I typed in 30 as the filtering number, I would see something like Tom 33, Jane 48, Bill 51, etc.

 

[khawar]

Have you downloaded and checked my sample

 

[yeppy12]

Have you downloaded and checked my sample

Yes, when I type in a number in the dialog box, the query returns no results.

 

[neileg]

Strange, it works fine for me.

 

[khawar]

If you are trying to get data by typing 30 in my sample and excpecting to get something like Tom 33, Jane 48, Bill 51 it will never happen
coz I havnt entered the data in the database
apply the query to your own data and check the result

 

[yeppy12]

If you are trying to get data by typing 30 in my sample and excpecting to get something like Tom 33, Jane 48, Bill 51 it will never happen
coz I havnt entered the data in the database
apply the query to your own data and check the result

Ok. I will try the query again with more data.

 

[neileg]

Ok. I will try the query again with more data.

Why not just use 2 or 3 as a parameter? It works, I promise you.

 

[yeppy12]

Ok. I will try the query again with more data.

Ok. The query works with my data. Thanks for all of the help.