Search results

I have created a report based off of a crosstab query. It is counting the number of instances that each group does a certain task and displaying the totals in the report. On one of the reports it has to also include the budget for each group. I was able to include this by using a DLookUp...

Thank you... that worked well. Figured it was simple. I am kicking myself, I should have known that.

I have a CrossTab Report that is getting the Counts of field values in a query sorted on CommunityGroup. I need to have another table's values inserted to do some calculations on these totals, so I used a DLookUp: =DLookUp("CBudget","Contract Budget","[CommunityGroup] = " &...

I couldn't get that to work... I think that maybe my relationships got messed up or deleted and caused the form to "break" because it was working correctly about a week ago. I am just not completely sure and don't want to risk messing things up further. I have attached the database file if...

I am having trouble on the Work Orders Form to get the SubTotal to calculate correctly. The SubTotal Control Source is: =DLookUp("[Services Total]","[Services Total]","[WOrderID] = '" & [txtWOrderID] & "'")+DLookUp("[Parts Total]","[Parts Total]","[WOrderID] = '" & [txtWOrderID] & "'") The...

I have realized that my control was updating from a static query rather than the sub-form or filtered results. It won't let me attach my database but msg me and I can email it to you or share via Google Drive. Can you look at frmStorageSub and let me know how I can get the filtered results in...

Actually both work just as well... not sure which is best practice though. I also need to know how to make the filtered information total in the subform and update a field on the main form with the filtered total.

I am trying to run an Inventory report in Access that calculates the Storage Cost based on if there is inventory for that month. It runs two different calculations based on what is being stored... I need the report to return the storage cost for each item based on this calculation and then...

I am trying to calculate the total [QtyProd] of a filtered subform and have the total update on the main form. I can get the total to calculate for the whole table but when I filter the table it doesn't update. I am probably missing something simple... let me know if you need any additional...

My name is Justin. I own a small IT Company in North Carolina, USA, called Triad Techx. I have been programming for a couple years but nothing heavy. I have dabbled in Java, JavaScript, C, C++, C#, SQL, VB, VBA, etc... I am working on several projects for clients that involve Access and VBA...