Hi
I am trying to extract records from a table using variables gained from another table, unfortunately I cannot create the correct syntax. I have 3 variables,i have shown my sql below
Sql = "select seqno,surname,forename,diedon,warcemetery from ByCemetery where surname = CWGC_surname"
If I have only 1 variable the code works but if I have more than 1 it does not, I need 3, the Surname, the forename and the diedon fields, this will enable me to extract the warcemetery field from the other table.
Any help would be much appreciated.
Regards
Ian Clegg
I am trying to extract records from a table using variables gained from another table, unfortunately I cannot create the correct syntax. I have 3 variables,i have shown my sql below
Sql = "select seqno,surname,forename,diedon,warcemetery from ByCemetery where surname = CWGC_surname"
If I have only 1 variable the code works but if I have more than 1 it does not, I need 3, the Surname, the forename and the diedon fields, this will enable me to extract the warcemetery field from the other table.
Any help would be much appreciated.
Regards
Ian Clegg