Search results for query: *

will try, thanks for both the suggestions, even the harsh response above. I didn't create this table, but the guy above me had some reasons for doing so. He's as much against denormalizing tables as the next person. Thanks again.

you can use the Dcount functions in columns in your queries. You can add them to reports and forms also. They are very useful, but add some overhead. MS Access help has a pretty good explanation of how to use them.

All, Here's the situation. I have a query with 35 columns containing dates. I need run the query and then somehow find to the total number of dates up until a certain point. For example, each date is a visit, so I need to total the number of visits that have occurred before, say, 12/31/01...