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!

Register Log in
  • 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!

Search results for query: *

  1. 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?
  2. spleenboy

    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.
  3. spleenboy

    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...

Part and Inventory Search

Back
Top