ProtocolPirate
Programmer
The following query never returns, even though there is an index on the name field in the Patient table:
SELECT p.Name FROM sheet4 AS s INNER JOIN Patient AS p ON p.NAME LIKE s.LASTNAME + ', ' + s.FIRSTNAME + ' %'
Now I've added a field to the spreadsheet before importing it into Access such that the last field, 'argh' is "Firstname, Lastname %", so the query reads like:
SELECT p.Name FROM sheet4 AS s INNER JOIN Patient AS p ON p.NAME LIKE s.Argh
Same result, the query never returns...
SELECT p.Name FROM sheet4 AS s INNER JOIN Patient AS p ON p.NAME LIKE s.LASTNAME + ', ' + s.FIRSTNAME + ' %'
Now I've added a field to the spreadsheet before importing it into Access such that the last field, 'argh' is "Firstname, Lastname %", so the query reads like:
SELECT p.Name FROM sheet4 AS s INNER JOIN Patient AS p ON p.NAME LIKE s.Argh
Same result, the query never returns...