Filtering

[alanris]

When using the MS Works database the "Find" command makes a new table of all records that include the chosen words.
The "Find" command on Access 2002 does not do this, nor does any filter command. Is there an easy way to do this in Access?

Thanks

 

[Smart]

You could write query selecting the fields you require and in the criteria section of the column that you want to use 'Find' type [ please enter value]
change the query to a make table query

When you run the query it will prompt you for your parameter and make a table with the data returned from the query

 

[workmad3]

no, as there is no real reason for a database to do that. Putting the results in a new table would mean that there is extra data redundancy, so is not a good thing to do. Can you not instead work with the record set that is returned with the results you want?

--Edit--

Damn, ninjaed

 

[alanris]

no, as there is no real reason for a database to do that. Putting the results in a new table would mean that there is extra data redundancy, so is not a good thing to do. Can you not instead work with the record set that is returned with the results you want?

--Edit--

Damn, ninjaed

Sorry for the delay in replying.

Thanks for your time on what must be a pretty basic question.
The table the MSWworks filters out is only temporary - it dissappears when the programme is closed, but I find it extrememly useful when finding people in my database of over 6000 photographs.

Maybe a recordset is what I need, but I find the "help" references beyond me.

I find it very strange that something so simple on MSWorks is so difficult on Access! I think I will have to stick to MSWorks, but I lost 400 records through not saving the entries - in Access you only have to "save" a change in the design of the table.

Many thanks again