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 Shaun E on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by spleenboy
-
selecting rows ina query where only the 1st field is distinct
Thanks PHV. That is very useful.Out of interest, I am use to working with standard SQL within an Oracle database. What does Access use? It seems to be a strange flavour of SQL. Also, what does AnyCol2 do in the example you gave?- spleenboy
- Post #6
- Forum: Microsoft: Access Queries and JET SQL
-
selecting rows ina query where only the 1st field is distinct
Kind of. I need the distinct values from col1, and any value from col2 i.e. 10 orange 20 grapes I am happy with any combination as long as I only get 1 distinct value for col1. Also, both columns are coming from diferent tables. I dont know if this complicates things in access.- spleenboy
- Post #3
- Forum: Microsoft: Access Queries and JET SQL
-
selecting rows ina query where only the 1st field is distinct
I'm an Oracle developer who is trying to get to grips with Access! I need to select records in a multi table query where it only checks that one field is unique i.e. col1 col2 10 apple 10 orange 20 grapes 20 pears I need it to return just 2 records, 1 for value for 10 and 1 for...- spleenboy
- Thread
- Replies: 7
- Forum: Microsoft: Access Queries and JET SQL
