Need Help with Conditional Formating??

[Guest]

I used to know how to do this but I can't now...

I'm entering information in this MS Access form that I created...

There's a date field where I have to input the "Accounting Months'" Date.

In the very next field, I need to input the Fiscal Year of the previous
dates' data.

I'm sure there's a way to where the computer can do that for me right?

Our Fiscal Year Ends on 8/31 and the new Fiscal Year starts 9/01.

Can anyone help me find a way of doing this?

Thanks for the help!!!

Sincerely,

Leonard Peacock

 

[Carl Rapson]

I used to know how to do this but I can't now...

I'm entering information in this MS Access form that I created...

There's a date field where I have to input the "Accounting Months'" Date.

In the very next field, I need to input the Fiscal Year of the previous
dates' data.

I'm sure there's a way to where the computer can do that for me right?

Our Fiscal Year Ends on 8/31 and the new Fiscal Year starts 9/01.

Can anyone help me find a way of doing this?

Thanks for the help!!!

Sincerely,

Leonard Peacock

In the AfterUpdate event of the Accounting Months control, do something like

txtFiscalYear = IIf(Month(txtAccountingMonths) < 9,
Year(txtAccountingMonths), Year(txtAccountingMonths)+1)

I'm assuming that FY 2008 starts on 9/01/2007.

Carl Rapson

 

[Guest]

Yes sir...

In the AfterUpdate event of the Accounting Months control, do something like

txtFiscalYear = IIf(Month(txtAccountingMonths) < 9,
Year(txtAccountingMonths), Year(txtAccountingMonths)+1)

I'm assuming that FY 2008 starts on 9/01/2007.

Carl Rapson