Need Help with Conditional Formating??

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
Leonard W. Peacock said:
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
Click to expand...

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
 
Yes sir...

Carl Rapson said:
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
Click to expand...
 
Back
Top