J
James
How do you fomar this so that is shows the month and year like this:
January 2003?
= [Forms]![frmDriver]![modate]
January 2003?
= [Forms]![frmDriver]![modate]
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
G
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.
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.
S
Sandy H
J
James
Thank you. But is shows the date 30 - 31 times. How do you just make the
date show once?
date show once?
Sandy H said:=Format([Forms]![frmDriver]![modate],"mmmm yyyy")
Sandy
AA Absolute Access
www.aaabsolute.com
James said:How do you fomar this so that is shows the month and year like this:
January 2003?
= [Forms]![frmDriver]![modate]
L
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
J
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.
report is open if will filter, or display all of the information in that
month and year.
Larry Linson said: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
L
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
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
James said: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.
Larry Linson said: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
G
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.
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.
James said: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.
Larry Linson said: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