Converting EOMONTH to Access Query

[LSGKelly]

Hi all...I need to convert an EOMONTH statement into an Access Query. The current formula looks like this:

=EOMONTH(B16,(-1))

B16 now = ProposedEffDate

Is there a function in Access that will do this for me?

Thanks

Kelly

[janders468]

I am unfamiliar with EOMONTH, is this a built in function (I am assuming you are using Excel?). We'll need a little more information to try and figure out what your requirements are. i.e. what are the inputs and the expected outputs of this function?