RE: Using partial dates in a query expression
- From: KARL DEWEY <KARLDEWEY@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Thu, 29 May 2008 16:32:00 -0700
Open your query in design view and scroll the grid to the right to a blank
column.
Click in the Field row and pull dow you date field name.
Edit that block in the grid to look like this --
Month_Day: Format([YourDateFieldName], "m/d")
In the Criteria row enter this --
[Enter Month/Day (1/14)]
--
KARL DEWEY
Build a little - Test a little
"LaurenM" wrote:
Hi all,.
I am trying to create an expression that will give me a numerical value
based on specific date criteria. I need to use only the month and day
information within a date. Since the year will always change, I can't include
it in my expression. For example, I want to write something like, If the
month and day is from 1/1 - 4/15, the result is 1. Do I need to convert the
date information to what the numerical equivalent would be in order to do
something like this? I am not all that confident with writing code but I
would appreciate any helpful advice with this.
Thank you in advance!
LaurenM
- Prev by Date: Re: parameter query for greater than date
- Next by Date: Re: Using partial dates in a query expression
- Previous by thread: Re: Update Queries
- Next by thread: RE: Using partial dates in a query expression
- Index(es):
Relevant Pages
|
|
