Recent content by Jim Stanicki

I was close at one point but I had my # on the wrong side of the ". Not only does it work but I learned something Thank you Jim

I am not yet comfortable with date compares. Would someone please tell me how this should be done? I present a form asking for start and end date and want to restrict report data to that date range. Thanks Jim Private Sub Report_Open(Cancel As Integer) Dim dteStart As Date Dim dteEnd...

One more question on DSum I have a " =Sum()" in the item header and it works as expected, totaling for the item. I replace it with a "=DSum()" and it seems to be a report total. How do I get the DSum to act like the Sum and just total for that item? Thanks Jim

A tip of the hat (and the little scale thing) to the both of you. I had a learning experience. The pound sign method worked (it was a date). Two more questions if I may. Sometimes after keying an expression then exiting the field. I return to find it reverted to the way it was. Is this Access...

Man I hate to be stupid but I just can't get this to work. My report prints "#Error" where it should be printing the Dsum field. This is what I am using.. = Dsum("[RMA Qty]","Inventory Transactions", "[created Date]< #" & [forms]![askdate]![txtStartDate] & "#")

I can't get either to work yet but whats the scoop on the ampersand? My book says they are used for concatenation and formating Thanks Jim

Would someone please tell me where I have gone astray? = Dsum("[RMA Qty]","Inventory Transactions", "[Inventory Transactions]![created Date]< Cdate([forms]![askdate]![txtStartDate])") Thanks Jim

Thank you all for helping me understand. Jim

Rolaaus, Thank you, sorry about the rant. I do appreciate all the help given here. I am a bit confused where to put the code you gave me. It looks to me like you are concatenating the the output from the form then opening the form. Thanks Jim

Rolaaus, I think the problem is too many options. Do I invoke the report from the form or the form from the report? Soapbox = On I am an old dog programmer trying to learn Access and also Microsoft terminology. I believe the problem I am having is with something we used to call scope. That...

Bob, When I move the date assignments to the Form_Close event the dates are not available to the report (I am prompted for them). How do I do the assignments so the report can see them? Also I would like to use them for the SQL that feeds the report. Thanks Jim

Bob, When I remove the AcDialog the form does not display at all it just launches the report. Should I put another option in its place? Thanks Jim

Rolaaus, I confirmed The foramt is short date. Then I tried your code and I got the same results. Thanks Jim

No, Just a plane old form

Runtime error 2450 Microsoft Office Access can't find the form 'frmStockLevelDates' referred to in the macro expression or visual basic code