Sales Records

[MintonMagic]

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

[Inky Phil]

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

[MintonMagic]

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

[Fenton]

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.