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 derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
How to have query select 1st record if several records are same
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- alyzar
- Post #5
- Forum: Microsoft: Access Queries and JET SQL
-
How to have query select 1st record if several records are same
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...- alyzar
- Thread
- Replies: 7
- Forum: Microsoft: Access Queries and JET SQL
