[RESOLVED] How to make Month as a Parameter

[girl81]

hi everybody..
i'm use a CR8.5 and Access database.
I want to make a Month as a parameter.

so i want to prompt the user for month (in Format January,February and ....) I retrieve date from database.But here i just can list out in Format 1,2,3 and .....Not January,February and ....I dont know well how to work with Formula Editor.So anybody can help me.

I'm also want to display a Month (in Format January,February...) on the report.I try to change at Format but there is no format like i want.

any helping is very much appreciated.
tq

[brucevde]

There are a couple of ways to handle prompting for a month name, here is one.

On the Edit Parameter Screen, set the parameter type to String. Click the Set Default Values button and add each month to the list. These values will appear in the combobox on the parameter prompting screen.

In the record selection formula use
MonthName ({Name of Database field}) = {?Name of parameter}


To format a date field to display just the Month Name.

Open the Format Editor.
Click the Customize button.
On the Date/Time tab set the Order combo box to Date.
On the Date Tab, set the Format combo boxes for Month, Day and Year to
Month - March
Day - None
Year - None

You could also create a formula that returns the MonthName and print it on the report instead.

[girl81]

tq bruce..

To format a date field to display just the Month Name.

Open the Format Editor.
Click the Customize button.
On the Date/Time tab set the Order combo box to Date.
On the Date Tab, set the Format combo boxes for Month, Day and Year to
Month - March
Day - None
Year - None

Now i know how to display the Month Name on my report.

On the Edit Parameter Screen, set the parameter type to String. Click the Set Default Values button and add each month to the list. These values will appear in the combobox on the parameter prompting screen.

In the record selection formula use
MonthName ({Name of Database field}) = {?Name of parameter}

for the above problem, it still under trying.hope can keep in touch for this problem next time.

tq so much