Search

Software

Question

Gravatar
Locked

INSERT A FIELD INTO AN ACCESS TABLE AT A SPECIFIC POINT

By excob ·
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

This conversation is currently closed to new comments.

1 total post (Page 1 of 1)  
+ Follow this Discussion ·
| Thread display: Collapse - | Expand +

All Answers

gravatar
Collapse -

Inapplicable concept

by Tony Hopkinson In reply to INSERT A FIELD INTO AN AC ...

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.

Back to Software Forum
1 total post (Page 1 of 1)  

Start or search

Related Discussions

Related Forums