Recent content by Garmani

Thanks I think I can get what I need by taking this approach, apologies if my explanation confused matters. Appreciate your help ....I might be back with more questions :) Regards GARMANI

Thanks for your reply - what I am trying to eliminate is the duplicate shipment number - you will see the date/times of receipt are different but relate to the same shipment - for the purposes of reporting I just need to ascertain the shipment receipt time which would be the first date/time. I...

I have attached an example of tables and query with duplicate shipment numbers I am trying to eliminate. Regards# G

Using DISTINCT still returns duplicated shipment numbers due to the fact that the Receipt date is associated to the Delivery Number (ie: 1 record per delivery) Hence the duplication of Shipment Number. To illustrate Table 1 - Shipment 123 this has for example 3 matches in Table2...

Apologies Could you enlighten me as to how to do this please Regards

Thanks for your response - I did try this previously - the problem being is some Shipments have multiple deliveries and each delivery on the same shipment shares the same delivery date/time. For example Table 1 - Shipment 123 Table 2 - Shipment 123 - Delivery A Shipment 123 -Delivery B...

Thanks for your response - I did try this previously - the problem being is some Shipments have multiple deliveries and each delivery on the same shipment shares the same delivery date/time. For example Table 1 - Shipment 123 Table 2 - Shipment 123 - Delivery A...

Relatively new to the forum, but need the benefit of some experience in a problem I cannot resolve. Simply - I have 3 pre-determined data sources which append to 3 different tables. Table 1 - Shipment Number Table 2 - Shipment Number - Delivery Number Table 3 -Delivery...

Yes its your function - As per previous attachment - the Deliv#Date field contains the data I want to return a week number. For the Fiscal year commencing 01/09/2018 to 31/08/2019. Apologies I am just trying to be aligned with your solution Regards Garmani

Thank you for your reply - you may have to guide me with this one as I am struggling to call the function Thanks Garmani

Thanks works fine with the null values

Hi Everyone - newbie poster Could you support with the following please- I have a list of dates dd:mm:yyyy for transactions which I need to allocate a week number to. Criteria is the Fiscal year starts on the 1st September each year. Thus 1/9 is always Week 1 Many thanks Garmani

Yes - called the module from the query - Thanks again

That's perfect - thank you so much for your help - much appreciated. Best Regards Garmani

Hi Arnelgp Attached excel extract of sample data output Highlighted colums are the Date/Time fields and the SLA field is the output from the below SLA: Abs(DateDiff("n",[VT11_DHL_Ver2]![Load_Complete],[ExportData]![asn_hdr__first_rcpt_date_time])\60) &...