Search results

  1. C

    Run multiple queries in one go

    In the process of doing that, I found some of my field types were less than optimal. After changing them, it doesn't seem to be struggling as before. New, cleaner version attached in case anyone's interested. I'm always open to suggestions, though!
  2. C

    Run multiple queries in one go

    Thank you for understanding my post, Pat! I've just been tidying up the indexes. Not sure it's made any difference. I agree about the continents, and was just about to make another 'master' table to perform that task. Sure thing :) I removed some superfluous stuff; hope I haven't left it too...
  3. C

    Run multiple queries in one go

    Situation: I'm tracking coronavirus deaths across 216 countries, updated daily via an append query on an Excel spreadsheet which I import. Although I've only been doing this for 5 months, the Access table containing all the records is already getting a bit twitchy. It only has 30,000 records so...
  4. C

    Previous Access User

    Hello :) I feel your pain. I'm as rusty as Prince Philip's prostate. Currently wishing I hadn't decided to use Access for my supposedly simple database, but I'm as stubborn as the royal old goat himself, so will be leaning heavily on the combined genius of this forum until I either remember how...
  5. C

    I hate Access

    Ola! I never post introductions in forums, but yours nagged me so nicely ... 😊 It's a couple of years since I had to use Access, and I'm extremely good at forgetting what I knew. I started a voluntary project (pandemic monitoring) and, since this data's going to mount up, thought I should use...
Top Bottom