Auto Month Input

[Guest]

I have a query that when you enter the two digit month ( January = 01 ) it
shows everyone born in January. Is there a formula I can enter that it will
automatically run based on the current month number.

This is what I am using now

BirthMonth: Format([Birthdate],"mm") - Then in a forms field I enter the
value.

Thanks - George

 

[Guest]

Change your BirthMonth column in the query to BirthMonth: Month([BirthDate])
and then in the criteria for this column put Month(Now())

 

[Guest]

Thanks - That works.....

George

Change your BirthMonth column in the query to BirthMonth: Month([BirthDate])
and then in the criteria for this column put Month(Now())

I have a query that when you enter the two digit month ( January = 01 ) it
shows everyone born in January. Is there a formula I can enter that it will
automatically run based on the current month number.

This is what I am using now

BirthMonth: Format([Birthdate],"mm") - Then in a forms field I enter the
value.

Thanks - George

 

[Guest]

Dennis - I did what you suggested and that works - but I ran into a problem.
When I sort it sorts by the year - how can I get it to sort by just the day
of the month, don't want to display birth year. After I updated the query I
created a form to display the info. In the date field I formated as dd/mmmm
which only shows the date and month but not in chronical order.

Thanks - George

Change your BirthMonth column in the query to BirthMonth: Month([BirthDate])
and then in the criteria for this column put Month(Now())

I have a query that when you enter the two digit month ( January = 01 ) it
shows everyone born in January. Is there a formula I can enter that it will
automatically run based on the current month number.

This is what I am using now

BirthMonth: Format([Birthdate],"mm") - Then in a forms field I enter the
value.

Thanks - George