Search results

  1. J

    Query between two selected records

    Wow, yes, this gives me a perfect starting point as to what i want to achieve. Many thanks. Andrew:):)
  2. J

    Query between two selected records

    Hi Experts. I have a query question..can't seem to figure this out....:banghead: I have two tables A and B.. In Table A, I would like to trim out rows not in between Min and Max numbers in Table B. The resulting Table should be Table C. Could anyone tell me what the SQL or how to design the...
  3. J

    Delete Records where record exists in another table

    Hi Folks I have two tables. Archive1 and Archive2 with exactly the same field setup. I want to delete from Archive1 where the record exists in Archive2. I've seen a lot of question of this sort on the web and here but I can't quite figure it out. Surely the query must be simple. Cheers...
  4. J

    Inserting

    the reason i don't want to use a form is becauase i would run this query everyday but i want to add 7 & 8 to the list of clients. I dont want to use a form to do this everyday. As i said before, the example above is a very dumbed down version. The final query would return about 60 rows and i...
  5. J

    Inserting

    Mahenkj22 Sorry.. it's a very dumbed down example of what i wanted to do. ID is meant to be ClientID in my database.
  6. J

    Inserting

    Hi all, I want to query below table as such. SELECT DISTINCT ID FROM Table ORDER by ID Table ID Field1 1 a 1 f 2 gh 2 fd 5 df This would give me ID 1 2 5 I also want to add on to the above query two more records 7 & 8 so i want the final table to look like ID 1 2 5 7...
  7. J

    VBA Loop through, check condition, replace

    Galaxiom, Bob Fitz Thanks I've managed to work through my problem with what you've advised.!! It's perfect for tracking changes to your records where they don't pass the validation. Appreciated.
  8. J

    VBA Loop through, check condition, replace

    Thanks guys! I'll adopt your advice for my database. Will get back to you on how I go!
  9. J

    VBA Loop through, check condition, replace

    Hi all, VBA newbie here i want to write a vba code to loop through a column in my table and check for a condition, and where it does not equal that condition i want it to display the whole row in a message box and ask to amend the field to meet that condition. If i say Yes i want the amendment...
  10. J

    Hello All

    Newbie here. New to Access. Looks like my job is going to be very data and access intensive. Hope to learn and share much from everyone here. Cheers A:D
Back
Top Bottom