Query question . Join 200 together .

[Sunline]

Hello all , im using Access version 2003 , still a learner .
Im wanting some advise on a quicker way to write very basic code when i write a query in advanced filter sort .
I have approx 200 to put in and i know from previous experience that i will run out of lines when i enter going thru Records , filter , advanced filter sort .
In the query table where they all are im unsure how to join these all together or link them to all run on one table only .
Im not linking tables or anything , just all in one table .
Could you point me in the right direction on how to get all these too work in one go .
Thanks .

 

[boblarson]

What do you mean "...approx 200 to put in?"

I'm not understanding exactly what you are trying to do and what you mean by "an advanced filter sort." How are you building this query and are you doing it in Access or in Excel?

 

[Sunline]

Definately Access 2003 , i have a basic table , i only know how to write a query going too on the top menu bar .
Records , filter , advanced filter sort , i then write the query in here and save it .
Then i go to Queries from Tables , i have 200 approx queries written and saved .

I would like to join these so all will open in the one table instead of indivdually .

I dont know what the correct term is too join all 200 together too have them all return results combined .

Is it a union , append , join , inner , outer . at least if i knew what it was i could start to learn how to do this .
Thanks .

 

[xenou]

What are some sample "queries" that you've written - let's say, three of them, and how would you like to see them all together at once?

 

[boblarson]

200 queries written? Wow, that is a lot of queries. And no, there is no real way to put them all together at once. But the big question would be - what are they and is there a better way to do what you are trying to do, but you don't know how to do, given your limited knowledge. We might be able to help with that but joining 200 queries together for one output - isn't going to happen.

 

[Sunline]

Ok thanks guys , my table is called PIX ONE ONLY , some query examples in first sheet .

The second sheet is what my table looks like .

Each row represents one query only .

I would like to add alot more and return results once these queries have done there filtering etc . Expected results would return what has been selected by my queries .

Thanks .

 

[Sunline]

sorry attachments didnt go in .

Excel Workbook
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X
1	PQ	Yea	Mon	Date	Day	Win	Place	Class	Stakes	R#	Fsz	Placing	Pon	Rno	Rfav	Horse	App	PQ3	PQ2	PQ1	App3	App2	App1	Nztr%
2	is null												183							PQ		is null
3								MDN					181V2		1			is null			A
4													181				A			is null				>0 and
5					Saturday			OPN HCP					250				is null	PQ	PQ				is null
6	PQ								>49999				200		>1 and				is null		is null	A	A	>85
Sheet1

Excel Workbook
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y
1	ID1	PQ	Yea	Mon	Date	Day	Win	Place	Class	Stakes	R#	Fsz	Placing	Pon	Rno	Rfav	Horse	App	PQ3	PQ2	PQ1	App3	App2	App1	Nztr%
2	14140		2011	Aug	05-Aug-11	Friday			Rating 70 SW+P	$13,000.00	6	11	3	197	5	3	Thornbirds		PQ		PQ	A	A	A	44
3	14141		2011	Aug	05-Aug-11	Friday			Rating 80	$13,000.00	7	10	10	191	3	4	Govind								45
4	14142		2011	Aug	05-Aug-11	Friday			MDN	$10,000.00	8	12	2	240	1	1	Whistling Straits					A	A		71
5	14143		2011	Aug	06-Aug-11	Saturday			Rating 70 SW+P	$13,000.00	1	6	5	216	3	1	Abbottabad	A			PQ		A	A	50
6	14144		2011	Aug	06-Aug-11	Saturday			Rating 80	$13,000.00	2	6	5	187	1	2	Cosabella		PQ		PQ			A	50
7	14145		2011	Aug	06-Aug-11	Saturday			OPN HCP	$20,000.00	3	6	5	177	2	1	Hurricane Mickey		PQ		PQ	A			57
8	14146		2011	Aug	06-Aug-11	Saturday			Rating 90	$15,000.00	4	6	5	168	3	3	Bindi			PQ	PQ				40
9	14147		2011	Aug	06-Aug-11	Saturday			Rating 70 SW+P	$13,000.00	5	16	8	202	4	7	Alderney	A							20
10	14148		2011	Aug	06-Aug-11	Saturday			MDN	$10,000.00	6	11	6	276	9	1	Runningdownadream					A	A		60
11	14149		2011	Aug	06-Aug-11	Saturday			Rating 70 SW+P	$13,000.00	7	10	1	209	4	1	Master Michael		PQ						29
12	14150	PQ	2011	Aug	06-Aug-11	Saturday			OPN HDL	$30,000.00	1	15	6	203	2	4	Honey				PQ				40
13	14151	PQ	2011	Aug	06-Aug-11	Saturday			3YO HCP	$15,000.00	2	10	8	236	1	4	Venetian Raider					A	A		55
14	14152	PQ	2011	Aug	06-Aug-11	Saturday			Rating 85	$25,000.00	3	7	3	219	6	6	Sherborne	A							20
15	14153	PQ	2011	Aug	06-Aug-11	Saturday			Rating 90	$30,000.00	4	9	9	255	2	4	Keep The Conflict	A				A	A		58
Sheet1

 

[boblarson]

I still don't understand why you have 200 queries to get this data. From the look of your screenshots it looks like you might be overcomplicating things. Can you, as was asked by xenou already, post the SQL for several of the queries so we can see what they look like? If you aren't sure how to post the SQL, just go into the query into design view and then on the Ribbon, go to the View tab and then select SQL View. Copy and paste that here.

 

[xenou]

It sounds like each query is just the entire table with a filter criterion. What is it that you are filtering on?

More "normal" would be a single form, with a combobox or listbox to select the criterion of interest - thus one form takes the place of all 200 of your queries. Using a multiselect listbox, you could also select one, several, or all of the records you want to see results for.