Sorting and filtering data

[Guest]

Is there a way to solve this problem? I have data containing 10 - 15 thousand
rows of data. Each time the data must be manually sorted and filtered. Is
this possible using a filter on the table, or a query, or a macro, or
creating a module?

decision criteria:

sort data by name, then date, then amount.

then find within each name if there are 4 or more different dates
OR
find within each name if there are 2 or more dates within 5 days where any
amount is greater then 20.00.

I would appreciate any suggestions.

Thanks!

Marianne

 

[Douglas J Steele]

You can create a query that returns the names of people with 4 or more
different dates:

SELECT PersonName, Count(DateEntry)
FROM MyTable
GROUP BY PersonName

and then join that table to your first table to only get the details of
those people with 4 or more different dates.

The other criteria (2 or more dates within 5 days where any amount is
greater then 20.00) is a little harder to implement, but you should still be
able to create a query that returns all names that meet that and join that
to your main table, as above.