Search results

In the detail, correct?

I have fields that I would like to total on my report but the fields are actually text calculations so I end up with a funny looking number with +E at the end. They show as numbers in my query and report, but they aren't. How would I get the sum of these fields on my report? Does it have...

Now it's asking me for a parameter value. I've done something very wrong somewhere along the line. Thank you for your help.

I'm trying to do it in the report and have set up my calculation exactly like the one above. Maybe something didn't transfer from the query but when I look at my report in data sheet view all the right numbers are in the right columns. thanks

So I tried it without the sum. I put =student1u+... All it did was enter each number from the column but didn't add them together?

Do you mean... =expression instead of =sum

Danke Ok, I did exactly what you said to do in the Query as well as the Report. When I input the calculation in the Query I get, "you tried to execute a query that does not include the specified expression 'SCHNO' as part of an aggregate function. SCHNO is a field in query, but is not...

thank you. ok, I've already opened it in design and changed it back to select query, but the query is empty?

I clicked on update query and now I cannot open my query or my report. Don't ask why I did it, stupidity?? Now when I try to open the query I get, "the query must have one destination field" would someone help me get of this or am I stuck with it. thanks:o

would it be easier to do the calculation in the query?

I have 20 columns across and want to get a total for each row. I also want a grand total for each group. Is this possible? thanks

How do you formulate for a total for each line in your report and then a grand total for each group? thanks

Hi again, can I preform a calculation and have it show up on my report. I'm adding together totals per school. Thanks boblarson, I almost have my report totally formatted!

Does access 2000 have this option?

ok, only one more question I swear... Can I calculate for totals of each school after I make my report or should I made new fields on the query beforehand. Thanks a lot too.

How can I have each school number start on their own page?

Do I "group by" after I make the report or during?

I'm making a report from a query. I have 8 schools with 8 school numbers, but when I make the report only the first school number comes up? I've sorted by school number before hand. Thanks

Can I make a report based on a Table and a query or is it one or the other?

I'm using my query to create a report but I don't want to display all the fields. I'm trying to sort, but when I choose the fields that I want sorted the values show as zero. I have to sort by four fields each based on the previous one, but when I try to sort them ascending (in query) the fields...