Return One Unique Instant Of A Field From A Query

[jesusoneez]

Hi,

I've been given a flat-file database to 'improve'. One field is simply titled 'Room' and refers to a room number in a school. I want to create a MakeTable query that will run through all the records and make a table containing one instance of each room number (for normalizing). Hope that makes sense!

Any help much appreciated,

Steve

 

[jesusoneez]

Don't worry everyone, found the query property I was after.