[mso] Re: ACCESS 2002 - DATE QUERY
- From: "DAVID A ROSS SR" <ross0362@xxxxxxx>
- To: <mso@xxxxxxxxxxxxx>
- Date: Wed, 10 Mar 2004 21:33:39 -0800
Jim,
Thanks for the info but what I failed to mention was I need all the records for
a particular month regardless of year.
I have a table called tblTICKLER which has numerous of items that are due on a
specific date (I.e. JAN 01, FEB 12, JUN 13 etc.). I want to have an query of
each month (I.e. JAN, FEB, etc.) to use for my different reports so if the user
wants to print out this the reports for JAN vice everything he/she can.
David
----- Original Message -----
From: Jim Pettit<mailto:j_e_pettit@xxxxxxxxxxx>
To: mso@xxxxxxxxxxxxx<mailto:mso@xxxxxxxxxxxxx>
Sent: Wednesday, March 10, 2004 2:48 PM
Subject: [mso] Re: ACCESS 2002 - DATE QUERY
David--
1) The window pops up because of the way you're calling the Date
function ([date]). Access thinks that's a field name, and, failing to
find that, figures that you want the user to input some value.
2) DatePart will only return the number of the month (1 for January, 6
for June, etc.)
3) To give you "JAN" or "MAR", you will want to define a query column
this way:
sThreeLetterMonth: UCase(Left(Format([dtDateField],"mmmm"),3))
--Jim
-----Original Message-----
From: mso-bounce@xxxxxxxxxxxxx<mailto:mso-bounce@xxxxxxxxxxxxx>
[mailto:mso-bounce@xxxxxxxxxxxxx] On
Behalf Of DAVID A ROSS SR
Sent: Wednesday, March 10, 2004 1:24 PM
To: mso@xxxxxxxxxxxxx<mailto:mso@xxxxxxxxxxxxx>
Subject: [mso] ACCESS 2002 - DATE QUERY
How does one retrieve the month only from a date field in a query? I
have a
dbase with different dates from various years. I desire to retrieve
only
certain months, say "JAN" or "MAR" for example.
I've attempted using the datepart("m",[date]) and Month([date])=1
functions
but they don't work. A window pops up each time asking for the date.
Thanks again,
David
_________________________________________________________________
Frustrated with dial-up? Lightning-fast Internet access for as low as
$29.95/month.
http://click.atdmt.com/AVE/go/onm00200360ave/direct/01/<http://click.atdmt.com/AVE/go/onm00200360ave/direct/01/>
*************************************************************
You are receiving this mail because you subscribed to
mso@xxxxxxxxxxxxx<mailto:mso@xxxxxxxxxxxxx>
or MicrosoftOffice@xxxxxxxxxxxxxxx<mailto:MicrosoftOffice@xxxxxxxxxxxxxxx>.
To send mail to the group, simply address it to
mso@xxxxxxxxxxxxx<mailto:mso@xxxxxxxxxxxxx>
To Unsubscribe from this group, send an email to
mso-request@xxxxxxxxxxxxx<mailto:mso-request@xxxxxxxxxxxxx> with the word
"unsubscribe" (without the
quotes) in the subject line.
Or, visit the group's homepage and use the dropdown menu. This will
also allow you to change your email settings to digest or vacation (no
mail).
//www.freelists.org/webpage/mso<//www.freelists.org/webpage/mso>
To be able to use the files section for sharing files with the group,
send a request to
mso-moderators@xxxxxxxxxxxxx<mailto:mso-moderators@xxxxxxxxxxxxx> and you will
be sent an
invitation with instructions. Once you are a member of the files group,
you can go here to upload/download files:
http://www.smartgroups.com/vault/msofiles<http://www.smartgroups.com/vault/msofiles>
*************************************************************
*************************************************************
You are receiving this mail because you subscribed to
mso@xxxxxxxxxxxxx<mailto:mso@xxxxxxxxxxxxx> or
MicrosoftOffice@xxxxxxxxxxxxxxx<mailto:MicrosoftOffice@xxxxxxxxxxxxxxx>.
To send mail to the group, simply address it to
mso@xxxxxxxxxxxxx<mailto:mso@xxxxxxxxxxxxx>
To Unsubscribe from this group, send an email to
mso-request@xxxxxxxxxxxxx<mailto:mso-request@xxxxxxxxxxxxx> with the word
"unsubscribe" (without the quotes) in the subject line.
Or, visit the group's homepage and use the dropdown menu. This will also
allow you to change your email settings to digest or vacation (no mail).
//www.freelists.org/webpage/mso<//www.freelists.org/webpage/mso>
To be able to use the files section for sharing files with the group, send a
request to mso-moderators@xxxxxxxxxxxxx<mailto:mso-moderators@xxxxxxxxxxxxx>
and you will be sent an invitation with instructions. Once you are a member of
the files group, you can go here to upload/download files:
http://www.smartgroups.com/vault/msofiles<http://www.smartgroups.com/vault/msofiles>
*************************************************************
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or
MicrosoftOffice@xxxxxxxxxxxxxxxx
To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
To Unsubscribe from this group, send an email to
mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the quotes) in
the subject line.
Or, visit the group's homepage and use the dropdown menu. This will also allow
you to change your email settings to digest or vacation (no mail).
//www.freelists.org/webpage/mso
To be able to use the files section for sharing files with the group, send a
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with
instructions. Once you are a member of the files group, you can go here to
upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************
Other related posts:
