ACCESS FEED: RE: [MS_AccessPros] RE: Date field

Rabu, 28 Desember 2011

RE: [MS_AccessPros] RE: Date field

Duane,
I believe I was watching a video on normalization, though I cannot find the
link now. I will use the standard date formatted field for not and see how
it goes. I will then have to figure out how to pull all the information
that relates to a specific month and year. I am not quite sure how to do
that yet but I will be sure to let you know if I get stuck.
Thanks,
Bill

-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Duane Hookom
Sent: Wednesday, December 28, 2011 9:42 AM
To: Access Professionals Yahoo Group
Subject: RE: [MS_AccessPros] RE: Date field

Bill,Not sure of the context of Crystal's "own date field" but a date is a
date is a date. I would not consider changing a date field to anything else.
I might apply different formats or extract parts of the date with the large
number of date related functions. If I was tracking birthdays and had only
the day and month (no year), I might consider using fields for day and month
since a date field stores the year. Duane HookomMS Access MVP
To: MS_Access_Professionals@yahoogroups.com
From: Bill.Singer@at-group.net
Date: Wed, 28 Dec 2011 09:19:03 -0600
Subject: [MS_AccessPros] RE: Date field

I watched one of Crystal's videos and she created her own date field
rather

than use the date formatted field that access has. She created 3 separate

fields for month, day and year. I am going to be pulling some data out of a

database by month and I am wondering if creating my own date fields is going

to make this easier. I am thinking it will be easier to pull data for

February if I just run a query for all data where the month equals "2" and

the year equals "2012".

Any thoughts?

Bill

Minnesota

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

------------------------------------

Yahoo! Groups Links

-----
No virus found in this message.
Checked by AVG - www.avg.com
Version: 2012.0.1901 / Virus Database: 2109/4708 - Release Date: 12/28/11