query ideas

G

geebee

I have a report that simply gives a count of separate categories by
[enterdt]. I would like to amend that report to make sure that for each
category, i have a count of account numbers which were in the population the
previous day. for example, for May 10, if there were 458 records counted for
the "delinquent" category, I want right beside that to be the count of
account numbers that were in that category the day before

any ideas?

thanks in advance,
geebee
 
J

John Spencer

No unless you give us some more detail on your table structure.

For instance, are you updating the 458 records from ontime to deliquent in a
status field? Or do you have some criteria that determines by date that
something is delinquent.

COuld you post the SQL statement that you are using for the report?
 
Top