Search results

I have a query based on two tables, joined on one field (this field is the primary key in Table A. Table B doesn't have a primary key). When working inside this query, it gives me the option to delete records. However, when I try, the row disappears from the query but then if I save and close...

I have a macro that, when run, performs the following operations: a) Empties out an existing table b) Uses Application.ImportXML to pull in new data from an XML file c) Uses the following SQL to add a new column DoCmd.RunSQL "ALTER TABLE sampling ADD COLUMN PartStep TEXT;" d) Here's where I'm...

Table A has a field for Full Name (Bob Jones) Table B has two separate fields for first and last (Bob and Jones). Table B's contents are actually based on an XML import so I can not just change the table structure. I want to join the content from these two tables together based on full name...