If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
"First" function returning garbage - even after sorting previous q
Hi,
I'm running a database with some medical information in it where I need to identify the first malignant diagnoses for each patient. I used a query to filter the data, leaving only entries that are listed as malignant. In those queries I ordered the data by patient number and then date of procedure. When I run a third query, grouping by patient number and using the "first" function for the rest of the fields, the query does NOT return the first fields. The previous query that it's working from has already sorted the data, though! Why is it still picking arbitrary entries? How do I get around this? Thanks for any help. I hope I explained it alright. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Fill-in field - returning to a previous field. | Lorrie | Mailmerge | 1 | December 13th, 2004 07:39 PM |
Nesting Address function within Index function | mserber | General Discussion | 3 | November 5th, 2004 02:01 AM |
Function to calculate a team's form over previous 3 games only | Jock | General Discussion | 1 | October 7th, 2004 06:37 AM |
Why this is not returning to the previous control | Tru Dixon | General Discussion | 3 | August 12th, 2004 12:02 PM |