using post code as criteria

[rick roberts]

i have a query that contains full addresses in one box. i want to viewall addresses hich contain the same first 3 digits through a criteria -being able to insret the required post code manually . is this possible or will i need to put he post code in a separate box

 

[Mile-O]

You'd be better to split your address into all its separate components in your table that way, when running queries, you can concatenate the address if necessary. That way you'll find it easier to run queries on areas, cities, etc.

Having the post code in a seperate field would also be good and you can use the Left() function in your query to obtain all addresses with the same postcode.