At work we have a database with 2 relevant columns: An account number and a day that account was approved. I'm designing a query that for a given date range, will give the number of accounts approved on EACH day in that range. Simple enough. Problem is, EVERY day in the range needs to appear, whether there were any accounts approved on that day or not. I can't figure out a function to get the entire range. The end result should look like this

Date Accts_Approved
12/1/4 3
12/2/4 0 (or blank is fine,also)
12/3/4 7

as it is now, I'm just Counting accts by Date and it would look like this:

Date Accts_Approved
12/1/4 3
12/3/4 7

Ok Bud, time to start thinking 4th dimensional. This is what you need to do: I am going to describe it and if you need further help, coding it let me know. Here goes:

Start by using the beginning date and ending date to build a temporary table that will have all the date slots in it whether you use them or not.

Next, take the dates that you do have and go populate your temp table. After this, you now can run your report against the temp table with the complete slots. When you close your report, delete all recs in the temp table.

You can run a query against this temp table instead of a report if you need this for a query as well.

Hope this helps.

RU1