Replies

What article is that?

We jumped a few hoops but got it. In the sub report I placed a text box named [UnitSum] in the details section with the expression =Sum([Quantity]). In the main report I placed a text box in the details section with the expression =[Reports]![rptAmazonorders]![srptAmazonOrderDetails].[Report]![UnitSum] with the running sum property set to over group. Then I referred to that text box in my date footer and returned the correct total.

Thanks for helping.

OK James, we are getting closer. I now get a return but no a correct return. On the sub report, when viewed by itself, the total is correct, but the total is not correct when viewed in the report. At least the syntax part of the problem is corrected and I thank you guys for that. I am sure it is something simple…it always is with me.

Thanks Wendell. I had tried that syntax. =Sum([Reports]![rptAmazonOrders]![srptAmazonOrderDetails].[Report]![Quantity]) I don’t get an error but I get nothing. If I drop the “Sum” I get a result of the first record which happens to be 1. The expression also returns 1 if I drop the name of the main report. The expression builder does not add the name of the main report but like the article you referred me to, the help file adds the main report name so I had tried that.

I ultimately discovered that Office 97 will install on XP without error if installed before SP2 patch.

Sorry, I wasn’t clear that I am using Access 97. Access 97 does not recognize the MonthName function but it must have a way to convert 12 to December.

Got it! You use the Format function. Format([aDate],”mmmm”).

You are right RG! I went into the BIOS and confirmed 250GB. WOW! I am really getting old. Sorry fellows.

I received this error when I used the RUN command: LoadLibrary(“C:Program FilesMicrosoft OfficeOfficeHTMLHTMLMARQ.OCX”) Failed – Invalid access to memory location. I will try the link to Microsoft Support. Thanks for your help.

Thank you Hans. Once again after I read the help for MOD and WEEKDAY, I must acknowledge the Lounge really provides a great service to us would-be Excel users.

And I take it a custom series must be “regular”.

Thanks for the links and sorry I’m slow getting back. You know, when it rains it pours.

Hmmm…..Thank you Steve, I will give that some serious thought.

Thank you Joe and Hans. I see that my accumulated attachments would make the .pst file much larger than the original copied and therefore not completely overwrite the file.

I am using Outlook stand-alone. So if I were to make a copy of the .pst file prior to creating my emails with their attachments, I could then restore the .pst file after the emails are sent. Does that sound reasonably safe?

Well my friend, you have never failed me yet. Thanks especially for the MsgBox tip.

ps I am retired now but still dabbling. The first thing I did for my predecessor is introduce him to Woody’s Lounge.

Try Format(UpdateWeek,”mmmm”) in a new column to get your months sorted decending. Place this column before the WeeklyUpdate column so it sorts first. The use the query for your report.