Jump to content
Sign in to follow this  
MintonMagic

Sales Records

Recommended Posts

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

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×

Important Information

By using this site, you agree to our Terms of Use.