Search results

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...

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

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

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

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...

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.

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