calling a function

[amillia]

I have a function that i want to use to format a julian date as a regular date. Where do I put it? so I can use it on a field in a query. I'm am quite sure this is an easy question but I don't know so I had to ask. Thank you.

 

[jebry]

Hi!

Put the code in any Module that isn't a form module and use the Public Keyword at the beginning:

Public YourFunction(JulianDate As Date) As Date
etc.

Then is SQL you use:

Select YourFunction(JulianDate) As StandardDate

Or, in the query design view, put this in the Field line:

StandardDate: YourFunction(JulianDate)


hth


Jeff Bridgham
Purdue University
Graduate School
Data Analyst

 

[amillia]

Thank you, It works beautifully.