How to have query select 1st record if several records are same

[alyzar]

Greetings,
I have some mediacre fee shcedules that contain "CPT Codes" which contain codes that have several different fee's associated with them.
Example:
CPT CODE
10021 $$$$
10021 $$$$
10021 $$$$

What I would like to do is have a query select just the first record when there is are multiple selections. Is this possible?

Thanks

Brad

 

[dhookom]

I doubt this is possible without having another column or columns that identify the order. If there are no other unique columns/fields then you may be out of luck.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[danvlas]

Select DISTINCT cpt, code from TableName

Not sure if it gets the first, but it doesn't matter anyway, since it gets only one of them...


HTH




Daniel Vlas
Systems Consultant

http://www.geocities.com/danvlas/AutoMail.html

 

[Remou]

Do you mean lowest?

[tt]SELECT Code, Min(Fee) FROM tblTable GROUP BY Code[/tt]

 

[alyzar]

I downloaded again the .csv file from medicare's site and there was another column, which i did not see the first time. There is a column "Note" which has "#" next to the data that I require. So in the query i placed "#" in hte criteria area.

Thanks

Brad

 

[dhookom]

You aren't answering any questions or providing any additional required information. Can you be more specific or provide sample data and the exact records you want to select?

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[PHV]

Duane, I think that Brad has solved his issue ...

 

[dhookom]

Oh, you must have found your crystal ball ;-)

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]