I have tried these solutions, but I believe I am either missing a key concept, making the issue harder than it deserves to be, or just plain incompetent-I vote the last one.
I created a table that was simply the dates and then used a relationship with a table where the result was to be used. I just couldn't get it to pull in the data and work correctly. I don't need to worry about the null option because I have to have the [Date Received] filled in.
I think I am just making this harder than it needs to be.
Thanks to all for the help though!!!
