Question Locked

INSERT A FIELD INTO AN ACCESS TABLE AT A SPECIFIC POINT

0 helpful
2 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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

2 replies

by tony hopkinson

If you want the data to be ordered then you sort it.

'Place' only has meaning in that respect so if you want Tuesday between Monday and Wednesday

Then you insert Tuesday and sort by dayofweek.

If there is no column on which you can enforc the order you desire then you must come up with one.

This discussion is closed to new replies.