Need to feed data from one sheet to another sheet

[Jackblack1]

Hi

I have a table with about 12 columns include a column named dollar value and 5000 rows. This information is data entered. I would like new information that is entered in to be filter by dollar value and any value over 100 dollars sent to another table, can anyone help me do this.

Thanks

Jack

 

[Joe4]

You could do that with a Make-Table query (see Access' help on Action queries), but you may not need to do so. You can simply create a query based on your table that only returns the values that you want. Usually if you can create a query to do so, there is no point in writing it back to a table. You can run reports/forms off of queries just the same as you can with tables.

 

[Jackblack1]

Great I'm going to try it right now and see what happen, be right back

AND THANKS!