Recent content by HockeyFan

works great. thanks.

this is exactly what i had in mind. I will give it a try and let you know how it went. thanks in advance.

I would like the database to open with absolutely no ribbons. And i don't want the user to have to click anything to minimize or close it. That was always possible in past versions, but I can't figure out how to do that when creating a new database in 2007 version.

let me clarify. I would like it to be not visible when users first open the database.

When creating an Access2007 database, is there a simple way to have the entire ribbon to be not visible at all? I read all through help and I can't seem to figure out how to make it go away.

Most excellent MajP, now I understand. Use my original query and then get the subtotals from that one in a separate query. Thank you very much for your assistance.

It sounded so simple, but I'm having a lot of trouble creating this new query. My original query with all of my field names is 2 posts up. Are you able to give me a little assist please?

I've never done that before. I've done subforms, so I'm assuming it's a similar concept. So would I create a whole new query such as duane suggested above, and then use that as the record source for the few fields that I need sub totals on? And I'm also assuming they will be linked by some...

I was thinking that If I create sums in my query, then it would not show each individual record in the query. I want it to continue to show each individual record in the query becauase I use the detailed record information in my report also. That is why I was just hoping to find a way to total...

moved topic to report forum.

I have a query and it is doing just as I want it to. It displays each record, and also has a field called 'status' that can have five different values. The possible choices in this field are 'selectstatus'(the default), the other choices are, 'monitoring', 'working resolution','deferred', or...

That's exactly what I need.

I actually do have group by right now. I feel that my query is working exactly like I would expect it would. here is my query. I need the query to continue to show the details for each record, but I need the grand totals for each of the category values. that's why I wanted to find a way...

everything is good in the query, I just need to figure out how to get the totals in the report. If i do totals in the query, then it won't output each individual record, and i need that information also. That's why i was trying to get totals in the report.

bigred, I need the query to output all of the fields just like in gruuuu's post, however on the report, I want to be able to have a total for each value. The reason why I need it this way is because the source of the report, is the query, and there are many other fields on the report that are...