James

[James]

How do you fomar this so that is shows the month and year like this:
January 2003?

= [Forms]![frmDriver]![modate]

 

[Graham Mandeno]

Hi James

Set the Format to:
mmmm yyyy

--
Good Luck!
Graham Mandeno [Access MVP]
Auckland, New Zealand

Return mail address is invalid in a vain attempt to reduce spam.
Feedback is welcome at: (e-mail address removed)
Please post new questions or followups to newsgroup.

 

[Sandy H]

=Format([Forms]![frmDriver]![modate],"mmmm yyyy")

Sandy
AA Absolute Access
www.aaabsolute.com

 

[James]

Thank you. But is shows the date 30 - 31 times. How do you just make the
date show once?

=Format([Forms]![frmDriver]![modate],"mmmm yyyy")

Sandy
AA Absolute Access
www.aaabsolute.com

How do you fomar this so that is shows the month and year like this:
January 2003?

= [Forms]![frmDriver]![modate]

 

[Larry Linson]

Thank you. But is shows the date
30 - 31 times. How do you just make the
date show once?

You'll need to clarify where and how you are using the recommended

= [Forms]![frmDriver]![modate]

for anyone to be able to help, I fear. Please clarify here in the newsgroup,
not by e-mail. Thanks.

Larry Linson
Microsoft Access MVP

 

[James]

I am going to have a drop down menu with the month and year. Then when the
report is open if will filter, or display all of the information in that
month and year.

Thank you. But is shows the date
30 - 31 times. How do you just make the
date show once?

You'll need to clarify where and how you are using the recommended

= [Forms]![frmDriver]![modate]

for anyone to be able to help, I fear. Please clarify here in the newsgroup,
not by e-mail. Thanks.

Larry Linson
Microsoft Access MVP

 

[Larry Linson]

I'm sorry, I still don't see enough information that could have any relation
to showing the date 30 - 31 times. If we are to be able to help you, you're
going to have to help us by at least carefully reading and responding to the
requests for more information.

You showed a statement,

= [Forms]![frmDriver]![modate]

and you indicated that "it showed the date 30 - 31 times". I asked where and
how are you using the specific statement above.

Please clarify here in the newsgroup, not by e-mail. Thanks.

Larry Linson
Microsoft Access MVP

I am going to have a drop down menu with the month and year. Then when the
report is open if will filter, or display all of the information in that
month and year.

Thank you. But is shows the date
30 - 31 times. How do you just make the
date show once?

You'll need to clarify where and how you are using the recommended

= [Forms]![frmDriver]![modate]

for anyone to be able to help, I fear. Please clarify here in the newsgroup,
not by e-mail. Thanks.

Larry Linson
Microsoft Access MVP

 

[Graham Mandeno]

Hi James

Didn't I answer this question 3 days ago in your thread entitled
"Drop-Box"??

--
Graham Mandeno [Access MVP]
Auckland, New Zealand

Return mail address is invalid in a vain attempt to reduce spam.
Feedback is welcome at: (e-mail address removed)
Please post new questions or followups to newsgroup.

I am going to have a drop down menu with the month and year. Then when the
report is open if will filter, or display all of the information in that
month and year.

Thank you. But is shows the date
30 - 31 times. How do you just make the
date show once?

You'll need to clarify where and how you are using the recommended

= [Forms]![frmDriver]![modate]

for anyone to be able to help, I fear. Please clarify here in the newsgroup,
not by e-mail. Thanks.

Larry Linson
Microsoft Access MVP