list a field value on base of other field using ms access query

[learning_grexcel]

Excel 2007

	A	B	C
1	col_date	field1	field2
2	1-Jun-12	xyz	85
3	2-Jun-12	abc	33
4	3-Jun-12	xyz	76
5	4-Jun-12	aasdf	84
6	5-Jun-12	sdf	85
7	6-Jun-12	abc	84
8	7-Jun-12	xyz	84
9	8-Jun-12	aasdf	11
10	9-Jun-12	mmn	85
11	10-Jun-12	mmn	84

<colgroup><col style="width: 25pxpx"><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>

Sheet1​

In the above table, I want to list all the field1 which has corresponding field2 values both 85 and 84

I want output like below. As you can see here the field1 values have both 85 and 84 corresponding code.
Excel 2007

	A	B	C
1	col_date	field1	field2
2	1-Jun-12	xyz	85
3	7-Jun-12	xyz	84
4	9-Jun-12	mmn	85
5	10-Jun-12	mmn	84

<colgroup><col style="width: 25pxpx"><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>

Sheet2​

I tried the below query but it lists all field1 which exists either 85 or 84 but I want to list all field1 which has both 85 and 84.

select col_date, field1, field2 from table1
where field2 = '85' or field2 = '84'

 

[Corticus]

lose the single quotes if field2 is numeric
replace the single quotes with double quotes if field2 is character

 

[learning_grexcel]

Yes it is text data/type. I tried with double quotes also, but it is still the same. It returns all values where field2 is '85' or field2 = '84' but I'm looking for output where field1 has both code '84' and '85'.