Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Query: multiple columns from single column
Hi, My database contains a register of X-rays which were taken in a hospital. Some patients have multiple X-ray images taken and consequently a single patient may have multiple entries in the original talbe. The fields I am considering are: - patient ID - type of X-ray (head, chest, leg, etc)...
