Search results

Thank you so much!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! I took and introductory course on Microsoft office last semester. In two weeks I start a course on Access only, so I won't have to shoot myself afterall. I appreciate eveyone's help! Thank the heavens for the Internet...;)

No that was the original calculation to add minutes + hours to get the totals. Now he wants me to seperate them each student (1-10) into U or C columns. Thanks for your help, but I'm not sure if I can explain myself clearly enough. I appreciate it.

The total hours/minutes for the C & U students is supposed to be on the same query page, so says my boss. He said "don't make two queries". I'm ready to shoot myself in the head at this point because he told me that I'm taking too long.

Hi and thank you, but no there are no rows with that command. My boss gave me this project and told me that the only way to learn it is to figure it out myself, isn't that nice? I put the select query calculation in the field heading correct and that will be my nw column? What do you mean by...

I'm not sure what you mean by update but it is a query that I have already run and need more specific information based on the query that I've already run. It's for student summer school hours which fall into two catagories, Capped and Uncapped. I already have the totals but now need to seperate...

Does an IIF function go in the criteria row? I want to say if place1 has a 'U' in it put it into column 'Stuent1U' but if it has a 'C' in it, I want it to go into Column 'Student1C'. Thanks to anyone who may help me.

ok,I'm trying to calculate the total minutes for summer school attendence. I have roughly 30 fields (three fields to calcualte per student). So far I've just created the Query and added empty fields with Student_1 to Student_10. My description may be too confusing, I'm sorry.

Thanks so much. One more thing: How would I set up the actual calculation? Is it in [] or () or sum(fileld name + field name)? thanks

Thank you. Could you give me some advice? I have multiple fields all with different amounts in them. Each answer will result in ten different fields starting: Student_1, Student_2. Do I enter the name of the fields or the actual numbers. Some are minutes and some are in hours, so the hours have...

I'm trying to do that but I don't think that I have the right formula... Is there a specific formula for adding fields?

I've imported an Excel file into a table and now I've created a Query from it. I now need to Add Fields (names are not in the table) and calculate totals for these renamed fields some of the answers are going to be the result of two or three fields. Any help would be greatly appreciated. thanks