query ideas

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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?
 
Back
Top