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

Table Field date problem

P: n/a
Hi guys,

I have a table with a date field in the format 01/12/04 what I need in the
same table is a field that just takes the month and year from the date
field.

I have been told how to do this for a text box but cant figure how to do
this in a table

many thanks in advance

keith
Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Keith Crooks wrote:
Hi guys,

I have a table with a date field in the format 01/12/04 what I need
in the same table is a field that just takes the month and year from
the date field.

I have been told how to do this for a text box but cant figure how to
do this in a table

many thanks in advance

keith


That's because it would be a mistake to do so in a table. You can calculate
these in a query so there is no reason to have them in the table.
--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com
Nov 13 '05 #2

P: n/a
On Thu, 30 Dec 2004 22:11:00 -0000, Keith Crooks wrote:
Hi guys,

I have a table with a date field in the format 01/12/04 what I need in the
same table is a field that just takes the month and year from the date
field.

I have been told how to do this for a text box but cant figure how to do
this in a table

many thanks in advance

keith


Why in the world do you need to do this?
If you have the date, and you say you already know how to display the
month and year, that's really all you need do. No need to save, what
is essentially duplicate data.
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.
Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.