Change of address
On 31/10/2008 in message
KateB wrote:
This is exactly my problem. I can record all the addresses, tests,
patients, etc, but am not sure how to tie the address to the correct test
in
queries at a later time. I think a combination of yours and Fred's
suggestions may work for me. Lots of trial and error to come!
Perhaps something like:
SELECT * FROM tblAddresses WHERE PatientID = RequiredPatientID AND
AddressFromIndex = RequiredDateIndex AND AddressToIndex =
RequiredDateIndex
Ohmigod I didn't say SELECT * did I?
Could be fun, hope you've got time to experiment :-)
--
Jeff Gaines Damerham Hampshire UK
"Why is it that when we talk to God we're said to be praying,
but when God talks to us we're schizophrenic?"
|