Recent content by hawaiianwarrior

That is partly correct, but it promotion are depending of quaters and timeframes during the year, like Halloween and Christmas. So it is not always the last ship date what gives the right answer. If the ship date is for example 25 May 2011, it falls in the 2nd quarter. but the last ship date...

Thanks for your quick reply, so in order to relate to the table deal details I have to do that with a query. Do I have to sort the query in a particular way? Because if I order for example on ship date (important field) then how does access know when the shipdate filled in on the mainform Orders...

I posted this thread before, I really hope someone can help me with this one. Yesterday I opened the 2003 version again on an old computer and the original VBA code worked fine, it adds the right results in the record. Why it goes wrong in this VBA code (in new 2010 database) I have no idea. I...