Recent content by tallenwa

Thank you. I tried setting the dteVal before, but couldn't get it to work. I'm close, so maybe your code will help. Travis

Hey, I really appreciate the response. That code greatly simplifies what I had before. But it didn't reset the 20day cycle based on the next date. I think I found someone who can help me crack this nut. I'll have to test their input, but here's the code they provided: Option Compare Database...

I posted this on the Query forum originally, but it may belong here as it's a module that I'm struggling with. I have a query [20 day vessel summary report query1] that finds the FirstOfBOL for each vessel in my table [20 day vessel Table]. I then have another query that has a...

I've simplified my question in the thread “Variable Grouping by Date” hoping to get some guideance. I have a query [20 day vessel summary report query1] that finds the FirstOfBOL for each vessel in my table [20 day vessel Table]. I then have another query that has a module[MyGroup3] that...

Bump. Any help out there would be greatly appreciated.

I need help writing a module that will sum the total insured value (TIV) for shipments incured within 20days. The module needs to look at the first vessel and set the BOL date for the grouping to 20days beyond. Once the 20day grouping is done, the next date becomes the starting date for the...

You've got it working for me. I had a data error that was breaking the code. Thank you very much and Merry Christmas!

Couldn't have come close w/o your help. I may have to break it into 2 queries as it locks up when I put it to task with a record set of 400+. Thanks again for your help, hopefully you won't here from me again:-). Have a good weekend! -Travis

Paul, Thank you so much. I've been messing with this thing all day. I removed the "Firstof" from your earlier code (dteVal = rst![FirstofB/LDate]) and it appears to WORK! I've added the TIV to the original query and Sum on it, and it appears to work. I'm going to increase my test...

Paul, your patience is beyond what I could ask. I've got the query built and the equation is: my grouping: myGroup([Vessel],[B/LDate]) I have the Total Set to "Expression" The Total for [Vessel] is set to Group By, and the Total for B/LDate is set to First. I cut and pasted the...

You've got me real close now, WAY closer than I was. The query calls the function and provides the grouping, but not quite like I need, so I'll try to clarify. Also, one piece of the puzzle that I over simplified was that the Vessel Name does not remain constant :-(. So my grouping is FIRST by...

Thanks for the help. No, the user will input a starting date and ending date (right now, I've just entered criteria in the in the query field while I try to get it to work). Paul, do I have the function run before the query (as an event in the form), or within it? Can you tell me what the...

I'm trying to write a query/report combination that will group my data by distinct Vessel and dates that are within 20 days of each other. So if I have 8 Vessels, the end result would group the vessels into three groups and sum them. If I could figure how to group them this way, I can easily...

I'm not very good at writing SQL, that's why I was hoping to do it in a query or report. In answer to Michael's good question, the 20days is around the first date of the group. Group 1: Vessel A B/L Date 01/01/02 - $100,000 Vessel A B/L Date 01/15/02 - $1,000,000 Group 2: Vessel...

Sorry, I used a poor choice for the dates. I'm not trying to extract the "day". I'm trying to sum the value field of the Table if the ship is the same and the BOLdates are within 20days of each other.