I am a novice Access 2002 user and I'd like to delete all rows where the "category" fields says "buyer" as I do not need this information in my Real Estate database.
For example, I tried setting a query in SQL view with these parameters:
DELETE FROM [dbRealEstate] WHERE [dbRealEstate].Category ="buyer"
But since this is a command and not really a query, I am wondering where to do this. I also am seeing people writing VBScript into Access, but am wondering where I can do this. I have extensive experience with VBScript but it has been several years since I've used it and I haven't ever paired it with Access.