Calculating the WeekDay Names each month

  • Thread starter Thread starter Steven M. Britton
  • Start date Start date
S

Steven M. Britton

I have a report that runs of a query based on a date
range. At the top of the report I have labels that go
from 1 through 31 and what I want to do is underneath
number one if I was in the Month/Year 06/2004 it would
read Friday and under 2 read Sat... And so on and so
forth. But it needs to be calculated, so when we run the
report for say 01/2003 underneath 1 it would read, Wed...

Any help or ideas.

-Steve
 
How would the report know when run "if I was in the Month/Year 06/2004"? Are
the month and year values in a form control or somewhere?
 
Yes, the queries criteria reads:

WHERE (((PAYROLL.DATEPERFMD) Between forms!
[frmCheckInReport]!StartDate And forms![frmCheckInReport]!
endDate)

-Steve
 
Yes, the queries criteria reads:

WHERE (((PAYROLL.DATEPERFMD) Between forms!
[frmCheckInReport]!StartDate And forms![frmCheckInReport]!
endDate)

-Steve
-----Original Message-----
How would the report know when run "if I was in the Month/Year 06/2004"? Are
the month and year values in a form control or somewhere?

--
Duane Hookom
MS Access MVP
--




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

I'm, not clear on what you're looking for, but if you wish to show,
across the header, the day of the week for the filtered records shown
on the report, starting with the first date chosen, ....
To show the first day of the filtered report, add an unbound control
to the header:

=Format(forms!frmCheckInReport!StartDate,"ddd")
for June 2004 that is Tue.
For each of the following days, add one to the above:
=Format(forms!frmCheckInReport!StartDate +1,"ddd")
Wed
=Format(forms!frmCheckInReport!StartDate +2,"ddd")
Thu
etc.

The form must remain open when the report is run.
 
Fred,

This works on the first date, but when I attempt to add +1
or +2 I get and #Error on the report? You have the right
idea of what I am trying to do, I want a header with the
numbers above and the days below.

-Steve
To show the first day of the filtered report, add an unbound control
to the header:

=Format(forms!frmCheckInReport!StartDate,"ddd")
for June 2004 that is Tue.
For each of the following days, add one to the above:
=Format(forms!frmCheckInReport!StartDate +1,"ddd")
Wed
=Format(forms!frmCheckInReport!StartDate +2,"ddd")
Thu
etc.

The form must remain open when the report is run.
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.
.
-----Original Message-----
Yes, the queries criteria reads:

WHERE (((PAYROLL.DATEPERFMD) Between forms!
[frmCheckInReport]!StartDate And forms! [frmCheckInReport]!
endDate)

-Steve
-----Original Message-----
How would the report know when run "if I was in the Month/Year 06/2004"? Are
the month and year values in a form control or somewhere?
Click to expand...
in
message
I have a report that runs of a query based on a date
range. At the top of the report I have labels that go
from 1 through 31 and what I want to do is underneath
number one if I was in the Month/Year 06/2004 it would
read Friday and under 2 read Sat... And so on and so
forth. But it needs to be calculated, so when we run the
report for say 01/2003 underneath 1 it would read, Wed...

Any help or ideas.

-Steve


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

I'm, not clear on what you're looking for, but if you wish to show,
across the header, the day of the week for the filtered records shown
on the report, starting with the first date chosen, ....
To show the first day of the filtered report, add an unbound control
to the header:

=Format(forms!frmCheckInReport!StartDate,"ddd")
for June 2004 that is Tue.
For each of the following days, add one to the above:
=Format(forms!frmCheckInReport!StartDate +1,"ddd")
Wed
=Format(forms!frmCheckInReport!StartDate +2,"ddd")
Thu
etc.

The form must remain open when the report is run.
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.
.
Click to expand...
Click to expand...
 
Try:
=Format(DateAdd("d",1,forms!frmCheckInReport!StartDate ),"ddd")

--
Duane Hookom
MS Access MVP
--

Fred,

This works on the first date, but when I attempt to add +1
or +2 I get and #Error on the report? You have the right
idea of what I am trying to do, I want a header with the
numbers above and the days below.

-Steve
To show the first day of the filtered report, add an unbound control
to the header:

=Format(forms!frmCheckInReport!StartDate,"ddd")
for June 2004 that is Tue.
For each of the following days, add one to the above:
=Format(forms!frmCheckInReport!StartDate +1,"ddd")
Wed
=Format(forms!frmCheckInReport!StartDate +2,"ddd")
Thu
etc.

The form must remain open when the report is run.
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.
.
-----Original Message-----
Yes, the queries criteria reads:

WHERE (((PAYROLL.DATEPERFMD) Between forms!
[frmCheckInReport]!StartDate And forms! [frmCheckInReport]!
endDate)

-Steve

-----Original Message-----
How would the report know when run "if I was in the
Month/Year 06/2004"? Are
the month and year values in a form control or somewhere?

--
Duane Hookom
MS Access MVP
--

message
I have a report that runs of a query based on a date
range. At the top of the report I have labels that go
from 1 through 31 and what I want to do is underneath
number one if I was in the Month/Year 06/2004 it would
read Friday and under 2 read Sat... And so on and so
forth. But it needs to be calculated, so when we run
the
report for say 01/2003 underneath 1 it would read,
Wed...

Any help or ideas.

-Steve


.
Click to expand...

I'm, not clear on what you're looking for, but if you wish to show,
across the header, the day of the week for the filtered records shown
on the report, starting with the first date chosen, ....
To show the first day of the filtered report, add an unbound control
to the header:

=Format(forms!frmCheckInReport!StartDate,"ddd")
for June 2004 that is Tue.
For each of the following days, add one to the above:
=Format(forms!frmCheckInReport!StartDate +1,"ddd")
Wed
=Format(forms!frmCheckInReport!StartDate +2,"ddd")
Thu
etc.

The form must remain open when the report is run.
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.
.
Click to expand...
Click to expand...
Click to expand...
 
Fred,

This works on the first date, but when I attempt to add +1
or +2 I get and #Error on the report? You have the right
idea of what I am trying to do, I want a header with the
numbers above and the days below.

-Steve
To show the first day of the filtered report, add an unbound control
to the header:

=Format(forms!frmCheckInReport!StartDate,"ddd")
for June 2004 that is Tue.
For each of the following days, add one to the above:
=Format(forms!frmCheckInReport!StartDate +1,"ddd")
Wed
=Format(forms!frmCheckInReport!StartDate +2,"ddd")
Thu
etc.

The form must remain open when the report is run.
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.
.
-----Original Message-----
Yes, the queries criteria reads:

WHERE (((PAYROLL.DATEPERFMD) Between forms!
[frmCheckInReport]!StartDate And forms! [frmCheckInReport]!
endDate)

-Steve

-----Original Message-----
How would the report know when run "if I was in the
Month/Year 06/2004"? Are
the month and year values in a form control or somewhere?

--
Duane Hookom
MS Access MVP
--

message
I have a report that runs of a query based on a date
range. At the top of the report I have labels that go
from 1 through 31 and what I want to do is underneath
number one if I was in the Month/Year 06/2004 it would
read Friday and under 2 read Sat... And so on and so
forth. But it needs to be calculated, so when we run
the
report for say 01/2003 underneath 1 it would read,
Wed...

Any help or ideas.

-Steve


.
Click to expand...

I'm, not clear on what you're looking for, but if you wish to show,
across the header, the day of the week for the filtered records shown
on the report, starting with the first date chosen, ....
To show the first day of the filtered report, add an unbound control
to the header:

=Format(forms!frmCheckInReport!StartDate,"ddd")
for June 2004 that is Tue.
For each of the following days, add one to the above:
=Format(forms!frmCheckInReport!StartDate +1,"ddd")
Wed
=Format(forms!frmCheckInReport!StartDate +2,"ddd")
Thu
etc.

The form must remain open when the report is run.
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.
.
Click to expand...
Click to expand...

I have no idea why it doesn't work for you. It worked fine for me.
Are you sure you added the +1, +2 etc. in the same position as I
posted above?

If Duane's DateAdd() method works, use that. We're both adding days to
the startdate.
Click to expand...
 
Back
Top