Query Question

[rockyjr]

Probably easy question, but I just cant figure it out.

Example of a list:
3118 3113
3115 3113
3113 2956

With this list, I need to create a query that will give me one list of all those numbers but 3113.

So that I can get.
3118
3115
2956

Thanks in advance,

Luc

 

[Brianwarnock]

Are we to understand that the list is of 2 fields A and b and that 3113 always appears in either A or B, not that it matters really thinking abot it.
query fldA <>3113
Union
Query FldB <>3113

Brian

 

[rockyjr]

Ya, well, the 3113 would be a WHERE clause... whatever... doesnt matter...

I just need to make one list showing all those numbers.

When you say... query A then query B... do I make 2 queries then make a UNION of those 2?

Sorry, never played with UNION query

Luc

 

[Brianwarnock]

Best to read the help and get the full picture rather than me give you one from memory. Just type Union into the help index.

Brian

 

[rockyjr]

Actually, I got it... thanks for your help!!

 

[Brianwarnock]

Good, HTH thanks for reporting the success.

Brian