Recent content by manybeats

Thanks again for your help vbaInet. I think the problem was a cloudy brain and perhaps too little caffeine. In the control source of my sum field, I had the wrong name. Somehow I put "TotalWithAdminFee" instead of "SumOfTotalWithAdminFee". Access even notified me that something was up with a...

I was worried my post wasn't entirely clear, so let's see if I can clarify somewhat: The queries that the union query are based on have total fields (two of the queries have a calculated total and the other two simply have a total manually entered by the user). Because the queries forming the...

I have a report with 4 subreports. Each grouping of subreports gives me a total and I have multiple groupings in the report. I want a detailed summary of all these group totals. E.g. Group A Total = $1000 Group B Total = $1500 Each subreport is based on a query and each query has a total. For...

I've tried placing the total in the report footer (basically the same expression as I have in the detail section, which adds up each sum from the subreport footers), but when I view the report, it only gives me the sum from the last grouping, not all the groupings. ------------------ I've...

So I used what you did and got everything working (I am working in Access 2010, so copied and pasted the nnz module and the changes to the sum formula). Thanks so much! Now.... I am trying to get the grand total with no luck. Basically, I copied the same total formula from the detail section...

I have some family visiting, but will take a look at your changes in the next few days. Thanks so much for your help - I really appreciate your time. I have read other posts about problems between report view and print preview, so it's not isolated to this database. I have not found a solution...

On the mainform of rptInvoice, txtTotalCELPA is the calculated total field that is not working. It works correctly on the first set of data, but all instances of it afterwards come up with the error. In the subreports, the sum fields where I've used Nz are in the report footer and are called...

Hi! I have created a report with 4 subreports located in the detail section of the mainform. Each subreport has a sum in the report footer. These sums are working. On the mainform detail section, I added a textbox which adds the sums from the 4 subreports. After the first grouping, the sum shows...

Go figure that after all this time working on a solution, I find one shortly after I make a post. On the After Update of my ECCodeFK I added: strFilter = "[ECCodeFK] = " & Me!ECCodeFK & "And [ProjectFK] = " & Me!ProjectFK Me!ECUnit = DLookup("[ProjectECUnit]", "[tblProjectEC]", strFilter)...

I have 5 tables and want the value from one table to be transferred to another, based on certain criteria. Basically, I have tblProjectEC, where rates for a particular project are stored. Then I have tblECReport, where details concerning actual expenses for a particular project are stored. My...

My syntax error makes sense, but I'm still getting the error message: "The Microsoft Access database engine cannot find a record in the table 'tblProjectEquipCons' with key matching field(s) 'ProjectEquipConsFK'" when I try to enter a new record on the subform. I think the link I have between...

Thanks for replying. Here is the database. I converted it from Access 2010. It's the form frmTimesheet_EquipConsSubform that I'm specifically having issues with.

I have a query that pulls information from three tables: tblEquipConsCode (table basically lists types of equipment - e.g. sampling supplies) ECPK ECCodeDescription ECDefaultUnit tblProjectEquipCons (table captures the project specific equipment and rates) PECPK ProjectFK (ties into my Project...

I've set my lump sum amount as you did your quote amount. I'm hoping it won't be too difficult to pull the correct information come time to produce the invoice. I'm pretty new to Access and every step seems to be a struggle these days! I've been thinking about whether and how to store the total...

braden - I took at look at what Replicon offers, but I don't think it will suit the needs I am looking for. Thanks anyhow!