Saints#34
Hall-of-Famer
- Joined
- Jul 8, 2001
- Messages
- 4,315
- Reaction score
- 772
- Age
- 42
Offline
I'm doing some work with MS Access and have very, very little familiarity with it.
I'm working with a database of bone mineral density scans. Each individual has multiple scans in the database at different time points. There are thousands (70,000 to be exact) of scans, though considerably fewer individuals obviously.
I am trying to limit my search to with certain criteria and I have it down except for one thing: the system treats each scan as an individual entry instead of each patient. So if I do a search and patient A comes up, amongst others, he will come up with 8 entries or so, one for each scan he underwent.
What I want is a way to limit it to the first scan available by date, or some variation of that.
Anyone familiar enough with MS Access to know how to go about that? I can contact the tech guys over here but they take forever, it might be days before I get a response..
Thanks in advance...
I'm working with a database of bone mineral density scans. Each individual has multiple scans in the database at different time points. There are thousands (70,000 to be exact) of scans, though considerably fewer individuals obviously.
I am trying to limit my search to with certain criteria and I have it down except for one thing: the system treats each scan as an individual entry instead of each patient. So if I do a search and patient A comes up, amongst others, he will come up with 8 entries or so, one for each scan he underwent.
What I want is a way to limit it to the first scan available by date, or some variation of that.
Anyone familiar enough with MS Access to know how to go about that? I can contact the tech guys over here but they take forever, it might be days before I get a response..
Thanks in advance...