Search results

John, It's amazing to see how my project is coming along. Many thanks to you and folks like you at the forum that are happy to share what you know. You can bet I'll be at this forum when I do have questions. It's nice to know there's a place to troubleshoot and toss ideas around. The links...

John, That did give me the results I'm looking for. I doubled checked the results against my manual calculations. It's all correct! Since I'm relatively new to db design, I've mostly worked from a visual perspective in design view of Access. To familiarize myself with code I review SQL and...

Hi John, An Excel spreadsheet was given to me to show how a harvest is currently recorded. Attached is a copy for reference. As you can imagine this current method is not the most efficient way to keep the harvest records. In this example we have 8 different trucks hauling up to 6 loads on 1...

Hi John, Glad to hear the full-disclosure helped. :) Thanks for letting me know we're "good to go" on the qryTruckTareAvg subquery results. I typed a post earlier today and must have hit "preview" instead of "submit". :o Your solution looks so much more efficient than the attempts I've made...

John, No problem, I’m happy to have your help. the exact attribute needed: Net Pounds per txtTruckNo by HarvestDate. Attached is a screen shot (NetPounds) that shows the math used to determine Net Pounds harvested by one txtTruckNo for one HarvestDate. the exact problem I’m having at...

Hi John, Your solution works very well, with running avg’s, totals, and counts. The results are exactly as they should be, thanks! “There’s more than 1 way to skin a cat.” That gave me a smile, so nice to have different ideas shared to resolve an issue. My next calculation will use the...

John, Well, I thought I had this. My issue remains that I need the running total. In reviewing this thread, I've tried to apply your recommendations. It's probably simple, I'm just stuck. In working with your solution, I replaced instances of TruckID with the actual field name fkTruckID...

Thanks for posting, that did it!

ByteMyzer, I appreciate your help and I certainly learned a valuable lesson. When posting a question, it is important for me to list exact information on my issue. You provided a simplified solution, however, due to my error in posting I'm still unable to get your solution to work. At this...

@John, thank you for answering my questions. You explanation about the alias helped me. Guess, I need to get this working first, then I'll know how to address your question: @ByteMyzer, thanks for your input as well. I've pasted the code from ByteMyzer. I'm getting an error that there is...

John, Thank you posting an example. The record count is a great idea. I'm sorry, in my initial question I didn't note my table names and did not give exact Field Name for those tables. Within your code I tried replacing some of the code with my table and field names. However, still unable to...

John, The data is recorded by TruckID and usually has one TareWeight per TruckID per given day. Multiple weights can be entered in one day (due to multiple vehicles). For each TruckID I need to average the 3 most recent TareWeight entries. For reference, 2 of my tables: TruckTareID...

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

After working on it some more it seems I'm there. Attached is the current version of the database. On qryFieldPlotCropList I changed 2 of the table joins. Now the query is returning the FULL list of test combinations already entered into the tblFieldPlotCrop. So when I go to enter a new...

After I posted, I realized it may help to look at the database. Attached here for reference. Many thanks!

I'm sorry for the confusion. I know I'm confused. Thank you for your kindness and continued help. I guess where I'm confused is the frmHarvestDates (attached screen cap). Prior to updating qryFieldPlotCropList, the Field/Plot/Crop Harvested combo box had a drop down list of 5 test...

The tblHarvestEndDate Criteria is set to Is Null. Entering another harvest event with no EndDate helped. Attached is a screen cap of qryFieldPlotCropList in design view. The query results are now returning the 1 field/plot/crop combination that does not have an EndDate. If I understand this...

Thanks so much. I wondered if I should have some harvest events without an end date. Great to know I'm still on the right track. Will keep at it. Many thanks!

Attached is a screen cap of qryFieldPlotCropList in design view. Your SQL syntax direction makes sense to me. I don't have this working right yet. Just thought I'd be sure the layout of qryFieldPlotCropList is correct. In a previous post I noted that I added tblHarvestDates and...

I've put an ending date field in the harvest table and placed the harvest end date field in the frmHarvestDates. Then I entered a harvest end date for the first test harvest event. Then I went to the qryFieldPlotCropList. There, I added tblHarvestDateFieldCrop which automatically joined to an...