Search results

  1. R

    Using Post/Zip Codes as criteria to update another column

    Hey guys, I managed! Thank you for your input! Could you delete this thread please? I’m worried as I stupidly used my name as a username 🤗
  2. R

    Using Post/Zip Codes as criteria to update another column

    UPDATE: I have managed to use wildcards to update the tables (e.g., 'like "D21 8**"') but then I just get one column with 1384 rows (the number of entries I replaced) saying 'District One' - how do I update information in one column based on information from another column?
  3. R

    Using Post/Zip Codes as criteria to update another column

    Ah my apologies, I can see how that is confusing! I meant I didn't know how to create new districts (i.e., break down the city into three districts) - but I think I managed that.
  4. R

    Using Post/Zip Codes as criteria to update another column

    No, I have two fields, 'District' and 'Postcode' (no 'City' field). Currently we are entering the city into the 'District' field, when in reality we should be entering the region of the city into this field instead (i.e., District One, District Two, District Three). I wish to update all district...
  5. R

    Using Post/Zip Codes as criteria to update another column

    That's a great idea, however sometimes referrals come through which are outside all districts' boundaries, and then we have to go by the doctor's practice's postcode (whom may be from the other side of the city, therefore be in a different district), but we still need the referral's postcode to...
  6. R

    Using Post/Zip Codes as criteria to update another column

    Hello! Thank you! :) Due to confidentiality I cannot show the table, however the headings are as follows: Surname - First Name - DOB - Address Line 1 - Address Line 2 - Postcode - District - Comments... and so on. The districts are necessary as healthcare leads require figures per district...
  7. R

    Using Post/Zip Codes as criteria to update another column

    Hi all, I hope you're all doing well and that there's someone here who can help! I am very new to Access and in my line of work I help manage a huge database within a healthcare setting. Right now my team are receiving referrals and for years they have been inputting the district as the city...
Top Bottom