Search results

  1. Slap

    Coronavirus - are we all doomed?

    The models are just that, models. The snowflakes won this time and we pandered to the worst case scenario. Reality is more people will likely die from the crippled global economy than would ever have done from coronavirus. They won't die tomorrow of course but over many years from reduced life...
  2. Slap

    Coronavirus - are we all doomed?

    Boris Johnson moved to ICU
  3. Slap

    Coronavirus - are we all doomed?

    https://www.bbc.co.uk/news/health-51979654
  4. Slap

    Coronavirus - are we all doomed?

    I drink too much, my vice, probably will kill me but it was a choice
  5. Slap

    Coronavirus - are we all doomed?

    We all make choices in life. It hurts when they bite back
  6. Slap

    Coronavirus - are we all doomed?

    With respect to all and in the spirit of debate/devil's advocate. BBC: The new figures include a further 246 people in England, with patients aged between 33 and 100 years old. All of them had underlying health conditions except 13 people, who were aged 63 and over So let's do the flu maths...
  7. Slap

    Coronavirus - are we all doomed?

    https://www.bbc.co.uk/news/uk-52012432 Now we are officially constrained
  8. Slap

    Coronavirus - are we all doomed?

    In the spirit of devil's advocate. Still almost all reported deaths have "underlying conditions" https://www.bbc.co.uk/news/health-51979654 Legacy is going to be our grandchildren paying for this...
  9. Slap

    Coronavirus - are we all doomed?

    https://en.m.wikipedia.org/wiki/I_Am_Legend_(film) Could it come true?
  10. Slap

    2 reasons I dislike AI

    @ doc Agreed, speed.. But sheep analogy comes to mind @ jon Remains to be seen but I can't help but be a glass half full on this.
  11. Slap

    2 reasons I dislike AI

    Go to top 10 bbc news threads Stock market crashes Bots following trends no human intervention! Discuss?
  12. Slap

    The Big get bigger, the Small get smaller

    Isn't that the whole issue with APIs/Algorithms when applied to popularity? Take BBC News Top 10 articles etc, once in there difficult to replace even though there are many newer articles. Lazy browsers don't look any further... Takes people to think outside the box, something computers aren't...
  13. Slap

    New Excel function

    Based on my experiences over the last 10 years & even more so with a new global employer for the last 3 months I'd say Excel is the most over used and abused application in the MS suite.. I watch hours being wasted battling files with umpteen nested lookups and isna formulae that become...
  14. Slap

    Service Unavailable

    Only by way of feedback, still very slow from UK. 25-45 seconds to load a page :eek:
  15. Slap

    Access and Power BI

    Fairly simple connection, but without a doubt it works best if the data is cloud based if you want to start any auto updating/refresh. I'm a newbie myself but have a dynamic dashboard with 2 X refresh daily via personal gateway. Host data on sharepoint in my case (. Xlsx) Works quite...
  16. Slap

    Score Predictor Form

    I am trying to set up a database to store and report on a football score predictor game for friends. In essence each week there will be 6 games for which each participant will predict the outcome (Home win, Away Win or Draw) with 1 point awarded for each correct selection. Where I am running...
  17. Slap

    Use of wifi capable barcode scanners with an access db

    You will need a device with screen/keyboard capability for remote work, else how would the user know when/what to scan. Warehouse scanners are available but they are pricey (>£400) and that's before you consider the interface. A quick search on that famous online shopping site shows refurbed...
  18. Slap

    Top N from Group Queries

    Brian, Thank you, I had left work in a rush and wasn't near a PC all weekend. You solution works perfectly, many thanks for your help! :D Regards Tony
  19. Slap

    Top N from Group Queries

    I've uploaded a sample and converted the query into a table for ease. A supplier can have multiple items but each Supplier + Item is the grouping, for which I need to return the last 6 records in chronological order descending (or less than 6).
  20. Slap

    Top N from Group Queries

    Ken, Thanks, I have everything sorted but I am not sure what you mean by doing a max 6. What I need at the end is: Supplier 1, Item A etc Supplier 1, Item A etc Supplier 1, Item A etc Supplier 1, Item A etc Supplier 1, Item A etc Supplier 1, Item A etc Supplier 2, Item B etc Supplier 2, Item...
Back
Top Bottom