Search results
-
H
Query Most Recent
I have weights that are recorded by date. What I need to query is the most recent 3 by date, then sum the most recent 3, and then average the most recent 3. Can this be accomplished with running totals? For instance, the average weight as of August 1st, and the average weight as of August... -
H
Query Joins Missing Results
This forum has been a life saver for me many times. Attached is database that I’m having trouble with. I have a query named QryNetPounds to calculate Net Pounds and Net Tons. This query is based on 2 queries QryHarvestLoadSum and QryRecentTareAverage, which are joined by Date and VehicleID... -
H
Average Top 3 Values
I enter Vehicle Tare Weight into a Table (named Tare), by Date and by VehicleID. Then I get top 3 (most recent) Vehicle Weights in query named QryRecentTare. Then I average the most recent 3 Vehicle Weights in query named QryRecentTareAverage. This gives me the average of the 3 most recent... -
H
Query Results by Date
Attached is my database project. My query, QryDMTons is returning the correct results for the following field names: DM Tons Adjusted 30% Expressions for field names are as follows: DM Tons: [Avg Of DryMatter]*[Net Tons]/100 Adjusted 30%: [DM Tons]/0.3 Prior to adding the above... -
H
Table Structure
I’m creating my second DB. The customer (dairy farmer) has crop fields harvested for feed. There are a variety of fields harvested, with varying acre size. At harvest time, one field has up to 10 different trucks hauling 6 loads of feed per day. Each load per truck is weighed. All loads per... -
H
Count Fields and Perform Calculation
In my query there are 9 fields that record weight of truck loads, Load1, Load2,...through Load9. Some fields may have no entry. I need to count ONLY the number of loads that have entries. Once loads are counted I then need to perform the following calculation: Gross Weight - (Tare Weight x... -
H
Average Fields and Null Values
This forum has helped me on so many occassions. Over the last 2 days I have searched and found answers so close to what I need. My issue: I have a query in which I average 3 fields. In some cases all three fields may be null. When they are I get an #Error in my average field. In several... -
H
Date Range in Report Header
I've created a report that opens via a form that requires a Start Date and End Date. I would like the date range to show up in the report header. I created an unbound text box in the header of the report and in the control source referred to form that generates the report as such...