Trying to get a Percentage

[Windsor302]

#2, each workers first 2 tested pieces are not counted towards the overall percentage needed but are still considered completed tasks

 

[Windsor302]

actually, maybe it will be easier this way, there are several categories along with the qualifiers, the only ones that will be taken for percentages are original and rework

 

[Beetle]

Assuming you're using a DCount in a query to retrieve the number of tasks tested (as in my previous example file), you could try something like the following;

TasksTested: DCount("*","Table1","Worker_ID=""" & [Worker_ID] & """ And MT_Type='original' Or Worker_ID=""" & [Worker_ID] & """ And MT_Type='rework'")

This may run a little slow, you'll have to test it to see if performance is acceptable. There may be better ways to approach this, but I couldn't say because I have no idea what the real structure of your application is.

 

[Windsor302]

should i send you a few rows from my database?

 

[Beetle]

If you want to upload a copy of your database, with just a few rows of dummy data, I can look at it. Keep in mind I would need to be able to see your tables and relationships as they actually exist in your real application, not just a few fields combined into one table like the last copy. That tells me nothing about your actual structure.

 

[Windsor302]

It wont let me, this info is using features...blah...blah

 

[Windsor302]

hey, here is the columns that pertain to this query.. thanks