Search results

  1. J

    Sum DLookUp in Report

    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...
  2. J

    DLookUp #Error on CrossTab Report

    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] = " &...
  3. J

    Form won't calculate totals

    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...
  4. J

    Total Report Fields using Criteria

    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...
  5. J

    Calculate a Total when Filtering a SubForm

    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...
  6. J

    New to the Forum

    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...
Back
Top Bottom