Help with Report

[Darin Inda]

Access 2002:

I have a report generated off of a query. In the query I
have built in the ability to run the query beween two
specific dates. I the report to do that, but I wish
the "Month" I am running displayed at the top of the
report. I understand how to put the between dates ranges
on the top of the report. But I just want the report to
read something like "September, 2003" based on the data
ranges set in the query.

Can anyone help?


Thanks,
Darin Inda, Paramedic, IT Guy
Universal-Macomb Ambulance
Sterling Heights, Michigan

 

[Darin Inda]

Working through this issue, I figured out how to get the
date on the top of the report using the DatePart
expression, but it's represented as "9" for September. I
want the word "September" rather than the number "9."

Help?

 

[Duane Hookom]

We can only guess since we have no idea how you are filtering the report. If
you have a parameter like [Enter Start Date], you can add a text box with a
control source of:
=[Enter Start Date]
Set the format of the text box to
mmmm

 

[Darin Inda]

Continuing to try and get this to work, I tried the
following expression:

=DatePart("mmmm",[RunDate])

It returned an error on the report.

Can anyone please lend some input on this issue?

Thanks in advance,


D. Inda

 

[Duane Hookom]

Why are you using DatePart()? Just place RunDate in your control source and
set the Format Property to mmmm.

--
Duane Hookom
MS Access MVP

Continuing to try and get this to work, I tried the
following expression:

=DatePart("mmmm",[RunDate])

It returned an error on the report.

Can anyone please lend some input on this issue?

Thanks in advance,


D. Inda

-----Original Message-----
Working through this issue, I figured out how to get the
date on the top of the report using the DatePart
expression, but it's represented as "9" for September. I
want the word "September" rather than the number "9."

Help?














.

 

[Darin Inda]

Duane:


Thanks for your help. I opted for your fist option where
I placed RunDate in my control source for that text box.
Then set the format property to mmmm.

You wouldn't happen to teach for New Horizons would you?

Thanks again,

D. Inda

-----Original Message-----
Why are you using DatePart()? Just place RunDate in your control source and
set the Format Property to mmmm.

--
Duane Hookom
MS Access MVP

Continuing to try and get this to work, I tried the
following expression:

=DatePart("mmmm",[RunDate])

It returned an error on the report.

Can anyone please lend some input on this issue?

Thanks in advance,


D. Inda

-----Original Message-----
Working through this issue, I figured out how to get the
date on the top of the report using the DatePart
expression, but it's represented as "9" for September. I
want the word "September" rather than the number "9."

Help?














-----Original Message-----
Access 2002:

I have a report generated off of a query. In the

query
I

have built in the ability to run the query beween two
specific dates. I the report to do that, but I wish
the "Month" I am running displayed at the top of the
report. I understand how to put the between dates
ranges
on the top of the report. But I just want the report to
read something like "September, 2003" based on the data
ranges set in the query.

Can anyone help?


Thanks,
Darin Inda, Paramedic, IT Guy
Universal-Macomb Ambulance
Sterling Heights, Michigan
.

.

.

 

[Duane Hookom]

No, I have taught some before but not for any of the big name companies.

--
Duane Hookom
MS Access MVP

Duane:


Thanks for your help. I opted for your fist option where
I placed RunDate in my control source for that text box.
Then set the format property to mmmm.

You wouldn't happen to teach for New Horizons would you?

Thanks again,

D. Inda

-----Original Message-----
Why are you using DatePart()? Just place RunDate in your control source and
set the Format Property to mmmm.

--
Duane Hookom
MS Access MVP

Continuing to try and get this to work, I tried the
following expression:

=DatePart("mmmm",[RunDate])

It returned an error on the report.

Can anyone please lend some input on this issue?

Thanks in advance,


D. Inda














-----Original Message-----
Working through this issue, I figured out how to get the
date on the top of the report using the DatePart
expression, but it's represented as "9" for September.
I
want the word "September" rather than the number "9."

Help?














-----Original Message-----
Access 2002:

I have a report generated off of a query. In the query
I
have built in the ability to run the query beween two
specific dates. I the report to do that, but I wish
the "Month" I am running displayed at the top of the
report. I understand how to put the between dates
ranges
on the top of the report. But I just want the report
to
read something like "September, 2003" based on the data
ranges set in the query.

Can anyone help?


Thanks,
Darin Inda, Paramedic, IT Guy
Universal-Macomb Ambulance
Sterling Heights, Michigan
.

.

.