A atomiden New member Local time Today, 04:34 Joined Apr 13, 2013 Messages 5 Jul 13, 2013 #1 hey guys i have an mdb problem usin ac2003...i have different queries with, single fields having one SumOF record, and i want to put them in a single query and rank them, but i the db cant find a relationship that can't link the queries,.any help?
hey guys i have an mdb problem usin ac2003...i have different queries with, single fields having one SumOF record, and i want to put them in a single query and rank them, but i the db cant find a relationship that can't link the queries,.any help?
Brianwarnock Retired Local time Today, 12:34 Joined Jun 2, 2003 Messages 12,667 Jul 13, 2013 #2 Are you saying that you have a number of queries with just one field? Union the queries and sort the result. Brian
Are you saying that you have a number of queries with just one field? Union the queries and sort the result. Brian