Search results

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

Thanks chergh, but I get the same 2450 error on both of your suggestions. Is this the way you would prompt for date to be used in a report? I need to reference the dates in the reports query as well as for headings in the report. I put the code in the report _open event. Thanks Jim

Sorry, I guess that wasn't clear, by next statement I meant the next executable statment after the form is displayed. StrEndDate = Nz(Forms("FrmStockLevelDates")!txtEndDate, "12/31/2010") Thanks for looking Jim

The code below displays the form and allows me to enter the dates then gives me an runtime 2450 error on the next statement. I would appreciate someone taking a look. Thanks Jim Private Sub Report_Open(Cancel As Integer) Dim StrBegDate As String Dim StrEndDate As String ' Put the form and...

Yes it works without the Having clause, but that is because that also eliminates the reference to the date on the form DateAdd('d',1,[Forms]![frmStockLevelDates]![txtBegDate]) Do I need the form to create a table with the dates then reference the new table in the query? Thanks for your help Jim

"If you post the SQL of you query we may get a better idea of the problem!" Thanks Neil, SELECT [Inventory Transactions Extended].Inventory.ID, [Inventory Transactions Extended].Inventory.Item, [Inventory Transactions Extended].[Transaction Type], Sum([Inventory Transactions Extended].[Stock...