Search results for query: *

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

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

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 trying to build a query that sums the value in one field if the "BOLdate" value is within +or-20 days of each other, when it's the same ship. I tried to do this within a report or the underlying query, but haven't had any luck. I can sort and group by month, but don't know how to...

I have a query that identifies a row and column, but can not figure out how to select the intersect of these in a joined table. Say the first two fields in my query retrieve II and c. One of the joined tables in my query is: a b c d e f I 1 2 3 4 5 6...