I am trying to insert fields into an access table on the fly. I want the insert point to be between certain fields. I have been successful in just inserting the fields on the fly using SQL INSERT command but I have not been able to specify WHERE in the table to INSERT.
Can anyone suggest a way?
Thanks,
Rick