Search results

I see. Another way to do the same thing. Thanks! mafhobb

I see. So when requering the form it is only updating the source data for the form, not for the controls if they have a difference control source. Understood. Many thanks mafhobb

That worked. Many thanks! I did try use Me.Requery in a form event but that did not seem to work. Could it be that my try was requering the form but not the controls on the form (ie, the combobox) or was it some other reason? I mean, is it the specific control that I need to requery? mafhobb

So I have this form "frmProjectHistory" with a subform "frmMaterialsUseSubform". There is a combobox on the subform called "cmbMaterialsUsed" with a row source: SELECT [tblMaterials].[ID], tblMaterials.[Material] FROM tblMaterials; On this same subform there is a button that opens a continuous...

If you look at the first query result, for example, you can see : "Can Muntaner, 2-Feb-21, 1, 25Kg Salt, 14.29, 14.29" but it should be "Can Muntaner, 2-Feb-21, 9V Battery, 5.90, 5.90" mafhobb

Hi. I am getting odd query results and I don't know why. I have a table (tblMaterials) that is a simple list of materials with a cost. Then I have another table (tblMaterialsUse) that is linked to properties so I can keep track of what materials are used for each property. At a table level this...

I have replaced the source to this: =dSum("[Subtotal]","[qryMaintenanceInvoice]") and it worked fine. (This query does return results) Then I added a second query which also returns results and it worked...

Hi bastanu. I have not tried the solutions in your last post yet. I will get to it right away. Many thanks mafhobb

I did try without VAL, but I will try again, just in case that I had a typo somewhere. If I open the report in PrintPreview or Print it, if any subreport has a value of "0", the subreport shows the "0", but the extended sum on the main report still shows "Type". In this case, however, clicking...

Sorry. That solution did not work, or maybe I did not know how to implement it. After days of trying to figure it out, I am still looking for a solution or a way to understand what is happening, nothing else. mafhobb

I have a report with several subreports. I have a subtotal sum on each subreport and on the main report an extended sum of all subtotals. When the sum of a subreport's subtotal is null or = 0 (It displays 0.00), the extended total on the main report displays a "#Type" error, however if I...

That did it! Thanks to both of you mafhobb

=Val(Nz([Report]![rptMaintenanceDoneSubrpt]![txtMaintenanceSubtotal].[Value],0))+Val(Nz([Report]![rptMaterialsDoneSubrpt]![txtMaterialsSubtotal].[Value],0))+Val(Nz([Report]![rptReservationsDoneSubrpt]![txtReservationsSubtotal].[Value],0)) The above is what I have in the extended total...

OK, yes. But...how do I refer to that total so I can have it as the rowsource in my textbox?

Thanks to your post I found how to get the total for any individual property, but what I need is the sum of all properties. Am I missing something? mafhobb

SELECT tblReservations.PropertyName, Sum(tblReservations.ResAmount) AS SumOfResAmount, DSum("ResAmount","tblreservations") AS Expr1 FROM tblReservations GROUP BY tblReservations.PropertyName ORDER BY tblReservations.PropertyName; From this query, all I really need is to extract is a unique DSum...

In this example, I am still required to enter a property name. This would work well if I wanted to know the sum of ResAmount for a specific property, but that is not the case. How can I do this and get an extended total without entering each property as a parameter in the query, but "all"? mafhobb

What if I have an extended total on the main report that adds the subtotals on the subreports? How can I tell the report's extended total textbox to NOT add that specific subreport's subtotal, which has a value of null? mafhobb

Hi. I have a report with a number of subreports. These subreports get their data from a query. How can I detect if one those queries returns no results so I can hide the subreport on the report? mafhobb

Yes, it is grouped by PropertyName, but I do want all properties to show up. I just wonder what do I need to do to get a running sum as shown at the top. Or is it impossible without criteria? Will it simply add all the values and that's it? mafhobb