Tom,
This query may be a start.
Query: Copy Of qry_Correction
Code:
Select id,
left(NotSimpleTense,1) & Mid(simpleTense,2) as REQd,notsimpletense
from
(
SELECT tbl_Words.ID,simpletense,notsimpletense
,iif(strcomp(left(NotSimpleTense,1),left(SimpleTense,1),0) <>0, "ChangeReqd","NochangeReqd") as WhatToDO
FROM tbl_Words
ORDER BY tbl_Words.ID
) where whatToDo ="changeReqd"
Produces:
id |
REQd |
notsimpletense |
8 |
Address |
Addressed |
10 |
advance |
advanced |
11 |
advise |
advise |
14 |
build |
build |
OR
Query: QRyResulttAllWords
Code:
SELECT tbl_Words.ID as X
, tbl_Words.SimpleTense
,Tbl_words.notsimpletense
FROM [Copy Of qry_Correction] RIGHT JOIN tbl_Words ON [Copy Of qry_Correction].id = tbl_Words.ID
WHERE ((([Copy Of qry_Correction].id) Is Null))
union select
id as x
,reqd
,notsimpletense
from [Copy Of qry_Correction]
order by X
Output:
X |
SimpleTense |
notsimpletense |
1 |
achieve |
achieve |
2 |
Acquire |
Acquire |
3 |
Acquire |
Acquired |
4 |
act |
act |
5 |
Act |
Acted |
6 |
Act |
Acts |
7 |
address |
address |
8 |
Address |
Addressed |
9 |
Adept |
Adept |
10 |
advance |
advanced |
11 |
advise |
advise |
12 |
Bring |
Bring |
13 |
Break |
Broke |
14 |
build |
build |
15 |
Build |
Built |