Anyway! Back onto subject!
I have done most of the above now, used vbscript for the most parts, but now i am in search for help on the next part, as i don't know what to do!
Right... At the moment my database has a form 'main' and on this form you can search for all the a certain date and define if you want it to show you monthly, quarterly or annually of when the next renewal for paying is, and you can also filter it by seeing the invoiced items and the not invoiced items.

Soo... seperately on this form i have a between dates function, and on this you can put in to different dates for the range, and then it has a 'preview' button, which i want when clicked to create a report for just the dates that is in the range! And that is what i need help on.

How can i create a report that will only show the between dates that has been inputted on the form when pressed the button to view the report?
Can anybody help? or if you are unsure i can say it again, but i really need help, my boss is on my back to get this completed, so any help will be muchly appreciated!

Thanks
Cracka