Search results for query: *

nevermind, i fixed it. What i did was i put the time percent column in twice, once specifying that i wanted it to sum and another using where and specifying the criteria. The final query ended up looking like this: Field: Role Form_Year ID Time% Time% Table: tbl_PL_Role HC_Year...

no dice, now i get no results at all.

Field: Role FORM_YEAR ID TIME_PERCENT Table: tbl_PL_Role HC_YEAR HC_YEAR HC_YEAR Total: Group By Group By Group by Sum Sort: Ascending Ascending Show: X X X Criteria: <1 That's my query as of now.

I have tried using the total function and the sum function. As of now its listing each part time employee, but its not totalling up their hours. Example: it lists 1995, attorney, .5 hours( for three different employees it'll list three different entries telling me this info). I want it to list...

I am trying to create a query that will give me the total full time/part time hours per year per position. Ex: I want to find out how many hours part time attorneys worked in 1995. I have the following fields in my query: Role, Form year, Unique Key, and Time Percent. In the time percent field...

The text box is controlled by a table, while the sub is controlled by a query.

I created a form for users to search by year and linked to a subform in which the data is gathered from a query. My problem is that i am not able to enter a year into my year search box. All i get is angry dings. I've checked everything on both the main form and the subform to make sure nothing...