In Access, Im trying to export the field "FirstName" from the query "qDemographics" into a function. The query has lots of records and I need someway to say that I need "FirstName" from the record that has ID (another field) equal to "16".
I need the value to be dropped into a replace function thats going to replace text in an instance of Word. So far, it seems it should go something like this:
replace (content, "stringtoreplace", valuefromfirstnamerecord16)
Eventually, I would need the ID to be pulled in as a parameter, but thats the next step. As a first step, can some help work out the code for a hard-coded record "16"?
Please help!
I need the value to be dropped into a replace function thats going to replace text in an instance of Word. So far, it seems it should go something like this:
replace (content, "stringtoreplace", valuefromfirstnamerecord16)
Eventually, I would need the ID to be pulled in as a parameter, but thats the next step. As a first step, can some help work out the code for a hard-coded record "16"?
Please help!
