Re: Match Today's Date

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Rick B (Anonymous)
Date: 12/01/04 

Date: Wed, 1 Dec 2004 10:12:40 -0600

You would need a new column in your query to pull the month and day of the
birthdate. Then, in the criteria, you can tell it to grab the month and
date of today's date...

New column...
BirthdayMD: Format([BDayFieldName],"mmdd")

Criteria...
=Format(Date(), "mmdd")

Obviously, you would need to replace [BDayFieldName] with the name of your
field.

Hope that helps,

Rick B

"Confused" <Confused@discussions.microsoft.com> wrote in message
news:958F0906-9578-4C6C-A516-9CC152518755@microsoft.com...
> I keep personnel information in several tables. One of the things that
has
> been requested is to put on our intranet when it is someone's birthday. I
> have that information. What I do not know how to do is to construct the
> query to only display the birthdays for today.
>
> I could put in a parameter to ask the date and then match that against the
> table. But because this query is going to be displayed via a web page,
> prompting for the date is not going to work.
>
> What I envision is FP loading the query. If there is a match for today's
> date, it will display that it is John Smith's birthday. If there are no
> matches, nothing will display.
>
> I am using Access 2003/FP 2003/IIS 6.x.
>
> I appreciate any help that you can offer.

Relevant Pages

  • Re: other table that stores data differently than ADO.Net datatable?
    ... >> would suggest making some sort of a "search" type of screen and filter ... >> criteria for your where clause, that will help slim down your list. ... >>> query the database everytime the user does a scroll (or page up/page ... >>> will display the next N records once the user has reached the last ...
    (microsoft.public.dotnet.languages.csharp)
  • Re:Date Range from Query in Report Header
    ... This works if there is a record to display. ... Is there a way to have the report ... display the criteria that was entered when there isn't a record? ... I assume you have an underlying query and in criteria ...
    (microsoft.public.access.reports)
  • Re: displaying multiple dates in a table
    ... If you cannot do that then you would need to build a fairly complex query ... that as the source of your birthday query. ... Sample Union query - ... display per month... ...
    (microsoft.public.access.queries)
  • RE: DBR error on empty
    ... > I have several DBR regions which pull from unique queries in an Access Db - ... > satisfy the criteria, unless there are no records which satisfy the criteria ... > Problem I encounter is when the query needs to display all records - it ...
    (microsoft.public.frontpage.programming)
  • Re: Filtering a Form with a Query
    ... I assume that line is in your criteria of the query for each of the four ... Do you really mean that if the combo box is null, don't apply any criteria at ... having difficulty getting the filter to display the desired result. ... Another example may be selecting a Supplier Code from the drop down list to ...
    (microsoft.public.access.forms)