Hi Everyone,

I apologize if something like this has been asked, I just couldn't find it anywhere.

Anyways I have an invoice table and I have a report designed. Now what I want to do is create a script that will ask the user what month & year they want to generate a report for, go to the report and find the records with these credentials.

For some reason I can't get it to only select a certain month for a certain year. It works without the year.

Any help is greatly appreciated. I am just confused!

Thanks

Roger

Hello Roger

Can you tell us please how the relevant dates are stored at present. Are they in date fields? is the year stored seperately from the month etc?

Phil

I have an invoiceDate field which in a date field format and is an autoenter for the creation date.

I also have and InvoiceMonth and InvoiceYear which are calculations to grab the invoiceDate month name and year.

Thanks

Why don't you pop up a custom message, with a global field for the month and one for the year, as input fields? Then use them in either a relationship or Find.