how to criteria greater than 0 from expression results.. !\!@#$

Hi,

Pictures are rarely much use, as is the case here - see advice in rule area.

Please upload the workbook and explain how you want to use it, and what results you expect in response to specific inputs.

As I said, upload the workbook. Your request is still not clear to me. For a start I don't know whether we're dealing with some macro code you're running or a standard function.

Manually add the results you expect to see so that we can see the end goal.

It is giving you a parameter screen because it is looking for a field Named "Total" It appears that you are trying to do a calculation but have the field named Expr1 and it has a unknown field name of Total in your QBE. Replace the field in question with the following:

PHP Code: 

TOTAL: [030]+[035]+[040]+[045]+[050]+[055]+[060]+[065]+[070]+[075]+[080]+[085]+[090]+[095]+[100]+[105]+[110]+[115]+[120]+[125]+[130]+[135]+[140]+[145]+[150]+[155]+[160]+[165]+[170]+[175] 


Do not include the following in the field Formula:. That is what is causing Access to generate the parameter request.

Suggest you upload a sanitized (limited data) of your database. Be sure to run a compact and repair and then zip the file. Difficult to analyze with out seeing it.

Just a thought before you upload. change your criteria to >1. Do not include the word Total in your criteria. It is implied by placing the criteria in your alias field called Total.

If you are having an issue with Access, why did you post an excel spreadsheet. You are forcing helpers to rebuild your database. Time is an issue for all of us. If you really want help, then help us to make it easy. Upload a sample database. I personally don't have time to try and reconstruct your database and guess at your set up. Mind reading is not one of my qualifications.