Twice a Month Query

[fuuumanchu]

I am wondering how should I go about setting up a query that displays dates that are printed out twice a month. I figured that generating a code that displays fields every 15 days will cause problems, since there are a different amount of days in each month. Is there a way to code a query to display a certain days of the month such as, day = 1 and day = 16?

 

[tlbroadbent]

I'm not following what you want to do. Could you post some sample data and the expected output so we could have a better idea of your requirement? Terry Broadbent
Please review faq183-874.

"The greatest obstacle to discovery is not ignorance -- it is the illusion of knowledge." - Daniel J Boorstin

 

[MichaelRed]

At least an easy way to check the date is the 1st or 16th

Public Function basBiMonthly(MyDay As Date) As Boolean

    Dim TheDay As Integer

    TheDay = Day(MyDay)

    If (TheDay = 1 Or TheDay = 16) Then
        basBiMonthly = True
    End If

End Function

MichaelRed
mred@att.net

There is never time to do it right but there is always time to do it over