Search results

I have just had a similar problem. In effect, your week has five days. So, of you take you shipping time and divide by 5 (integer division) and multiply by 7 you will get the number of whole weeks to elapse. Then add the result of modulo division to that answer you will get a total shipping...

Hi Andy, you don't describe how your data is structured, but I assume that you have three mechanic fields. If this is the case, then surely you could use a union operator along the lines of SELECT [Day], [Mechanic1] FROM [Table_Name] WHERE [Mechanic1] IS NOT NULL UNION (SELECT [Day]...