Search results

Maybe just a little help on sorting - ref attached screen shot In the large list all the orders are sorted starting with the cloest at the top and furthest away at the bottom. The ship date is entered on the order and then formatted to "week number" in the SQL argument. Therefore the orders...

That worked perfectly well, screen shot of implemented resolution attached. Thanks for your help

That sounds like a good place to start. Thanks for your help, I'll give it a try and see how it works out

I've tried to Count() and Sum(), but I can't figure out how to get the week numbers listed. For example, there chould be 200 orders on the screen spread out over 10 weeks - maybe 30 orders this week and 2 orders on the furthest out week. Also, as each week goes by, the previous week will fall of...

Hi Everyone, Although I've used this forum for help over the years, this is my first time joining as a memeber in the hope of getting some help. I'm using Access 2016, am self taught and picked up a reasonable understading of VB over the years. At the moment I am working on a shipping...