By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
431,965 Members | 2,043 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 431,965 IT Pros & Developers. It's quick & easy.

Date Range In access 2000

P: 2
I have a database that hold information that holds referral dates, this database hold more than one years worth of data, and will be used in the future. We need to create update queries that will up date a field called month based on the referral date. So if the referral date is between 1/1 and 1/31 it will update to Janunary. How do we write that so it will look at more than one year? (how do we make the year wild?)
Sep 17 '08 #1
Share this Question
Share on Google+
3 Replies


FishVal
Expert 2.5K+
P: 2,653
Hi, there.

Field called month is redundant. Kill it to death.

Kind regards,
Fish
Sep 17 '08 #2

P: 2
Ok then tell me how to runa query for a date range say 1-1-2008 to 3-31-2008 and then display the data by month to graph it. So the graph is number of patients see per quarter graphed by month

Hi, there.

Field called month is redundant. Kill it to death.

Kind regards,
Fish
Sep 17 '08 #3

FishVal
Expert 2.5K+
P: 2,653
Ok then tell me how to runa query for a date range say 1-1-2008 to 3-31-2008 and then display the data by month to graph it. So the graph is number of patients see per quarter graphed by month
Ok.

Access allows to use VBA functions (built-in and custom designed) in query.
The following queries will return:
  • Month number
    Expand|Select|Wrap|Line Numbers
    1. SELECT Month(dteDate) AS lngMonth FROM tbl;
    2.  
  • Month name (3 letters)
    Expand|Select|Wrap|Line Numbers
    1. SELECT Format(dteDate, "mmm") AS txtMonth FROM tbl;
    2.  
  • Month name (full)
    Expand|Select|Wrap|Line Numbers
    1. SELECT Format(dteDate, "mmmm") AS txtMonth FROM tbl;
    2.  

Regards,
Fish
Sep 17 '08 #4

Post your reply

Sign in to post your reply or Sign up for a free account.