converting lotus approach query to access

[aneats]

Trying to return a 'year' in a query.

I am converting a db from Lotus Approach to Access, but i can't work out how to convert this query. i know Access doesn't use 'Combine', so would anyone know how to convert this.
please.

The expression should return the 'Financial year' each time.


IIf(Month [D_PAID] >3,Combine(Year [D_PAID],'/',Right(Year [D_PAID] + 1,2)),Combine(Year [D_PAID]-1,'/',Right(Year [D_PAID],2)))

 

[Pat Hartman]

It looks like Combine() concatenates fields. If that is the case then the following should work:

IIf(Month([D_PAID]) >3, Year([D_PAID]) & "/" & Right(Year ([D_PAID]),2) +1), Year([D_PAID])-1 & "/" & Right(Year([D_PAID]),2)))

However, the statement doesn't make any sense. It is combining the year part of a date field with the right 2 digits of year as in 2002/03. when month > 3 and 2001/02 when month is less than 3.

 

[aneats]

I have tried that way and it doesn't work.
What i am trying to return is a financial year, in that if the month is >3 (march or 03) then the year returned is 2001/02, else it is 2002/03.
I have tried to put the '03' within quotation marks, but it didn't work.
ie: IIF(Month([D_PAID]>"03",Year([D_PAID]) &"/"& Right(Year([D_PAID]),2) +1), Year([D_PAID])-1 &"/" & Right(Year([D_PAID],2)))
i kept getting error messages saying that i had either left out quotation marks or i had a comma in the formula that shouldn't have been there, so i have tried many other variations, but without success.
Any ideas?