Embedded Files
This is sometimes required but beware the results can be unpredictable. A common one is when the data you are importing has the full name and you want to split it into FirstName and LastName. This section will show you one technique.
Figure 1: MS-Access showing a Query update (Note that clicking on the [View] button on the toolbar will allow you to change to SQL view)
The SQL looks like:
UPDATE tblNames SET tblNames.FirstName = Left(FullName,InStr(FullName," ")-1), tblNames.LastName = Right(FullName,Len(FullName)-InStr(FullName," "));
Editing a Query Update
Editing a Query Update
The only way I can get this to work is to right click on the query in the Objects list on the left and select Design View.
(Highlighting the Query object and clicking the Design view button on the ribbon bar is unpredictable. )
Google Sites
Report abuse