Replies

Thanks HansV. It works I’ve check and double checked all properties of each field and it would not work but after the 100 time I found the mistake. Thanks again for all your guys help. I have yet to try the Filter, but thanks again.

Yes it is. I had tried that too, and it didn’t work.
That is why I’m asking is that a limitation to Access, or not.
I’m also trying to see if there is a way i can make a report that look at all item released in a month.
I can make look up boxes (or filter boxes) for reports but how would you make one that looks for a month.

Sorry, #Error

It still Didn’t work. I changed the Day to DailyRate and it didn’t work still. Is there somewhere that explains the different Expression Functions better then what is at the bottom of the builder. Maybe I could make two different fields one to total the number of day past and another that takes the rate and times then days lapsed. I’ve tried even just trying to find total days and I’m having trouble with that too.

This would be a Form or Code