Help with Report

  • Thread starter Thread starter Darin Inda
  • Start date Start date
D

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
 
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?
 
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
 
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
 
Why are you using DatePart()? Just place RunDate in your control source and
set the Format Property to mmmm.

--
Duane Hookom
MS Access MVP


Darin Inda said:
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?














.
Click to expand...
Click to expand...
 
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


Darin Inda said:
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
Click to expand...
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
.

.
Click to expand...
Click to expand...


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

--
Duane Hookom
MS Access MVP


Darin Inda said:
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


Darin Inda said:
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
.

.
Click to expand...


.
Click to expand...
Click to expand...
 
Back
Top