How to Return a day?

[kai]

Hi,
I am looking for a function returning day like Day([orderDay])=Monday but
it only return1 "1". Is it possible?

Thanks

Kai

[Rick Brandt]

kai wrote:

Hi,
I am looking for a function returning day like
Day([orderDay])=Monday but it only return1 "1". Is it possible?

Format([orderDay], "dddd")

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

[Lyle Fairfield]

kai wrote:

Hi,
I am looking for a function returning day like Day([orderDay])=Monday but
it only return1 "1". Is it possible?

It might be worthwhile for you to learn how to explore the VB object
browser.

Open a standard module. Press <F2>.

The object browser should open. In the search box (beside the
binoculars) enter "day" without the quotation marks. Click on the
binoculars.

You will find properties, methods and functions whose names include
"day". From these you can pick:

WeekdayName
and
Weekday

With a little experimentation you can come up with something like:
Debug.print WeekdayName(Weekday(Date))
You will find that this shows "Tuesday" (or equivalent) in the
Immediate Window.

>From this you will be able to devise.

WeekdayName(Weekday([OrderDay]))

And soon you will be able to help answer questions of beginners and MLH
....

(I have used Access 2003 to check the contents of this post.)

[kai]

Thanks!!!

Kai
"Rick Brandt" <ri*********@hotmail.comwrote in message
news:pT*****************@newssvr21.news.prodigy.co m...

kai wrote:

>Hi,
I am looking for a function returning day like
Day([orderDay])=Monday but it only return1 "1". Is it possible?

Format([orderDay], "dddd")

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

[kai]

Thanks a lot!

kai
"Lyle Fairfield" <ly***********@aim.comwrote in message
news:11**********************@h48g2000cwc.googlegr oups.com...

kai wrote:

>Hi,
I am looking for a function returning day like Day([orderDay])=Monday
but
it only return1 "1". Is it possible?

It might be worthwhile for you to learn how to explore the VB object
browser.

Open a standard module. Press <F2>.

The object browser should open. In the search box (beside the
binoculars) enter "day" without the quotation marks. Click on the
binoculars.

You will find properties, methods and functions whose names include
"day". From these you can pick:

WeekdayName
and
Weekday

With a little experimentation you can come up with something like:
Debug.print WeekdayName(Weekday(Date))
You will find that this shows "Tuesday" (or equivalent) in the
Immediate Window.

>>From this you will be able to devise.

WeekdayName(Weekday([OrderDay]))

And soon you will be able to help answer questions of beginners and MLH
...

(I have used Access 2003 to check the contents of this post.)