Date in Report Header

[Guest]

I have a report where I would like to have a date in the header, The report
pulls the
data from a query with the following date criteria.
Between DateSerial([Enter Year:],[Enter Month (1-12):],1) And
DateSerial([Enter Year:],[Enter Month (1-12):]+1,0)
this works great, but when I put it in the report header so the year and
month will
show on the report, I get a syntax error.
What am I doing wrong?
Or is there another way to get the report to show the year and month?
Thanks for any help
Roger

 

[Duane Hookom]

How did you "put it in the report header"? Do you have a control source
property you could share with us?

 

[Guest]

Hi Duane
Sorry about the late reply, but was called out of town.
I used a list box and the between was used as a control source
My query uses the same in the date criteria, so when I open the report
It ask me for a year then a month. Works perfect except when I try to
put the date in the report.
I have used the list box with the between date before and it
worked perfect and showed a begin date and end date, but this time
it will not work.
Thanks for any help
Roger

How did you "put it in the report header"? Do you have a control source
property you could share with us?

--
Duane Hookom
MS Access MVP
--

I have a report where I would like to have a date in the header, The report
pulls the
data from a query with the following date criteria.
Between DateSerial([Enter Year:],[Enter Month (1-12):],1) And
DateSerial([Enter Year:],[Enter Month (1-12):]+1,0)
this works great, but when I put it in the report header so the year and
month will
show on the report, I get a syntax error.
What am I doing wrong?
Or is there another way to get the report to show the year and month?
Thanks for any help
Roger

 

[Duane Hookom]

A "list box" or a text box? I asked you previously for the Control Source
but you seemed to have ignored my question.

--
Duane Hookom
MS Access MVP

Hi Duane
Sorry about the late reply, but was called out of town.
I used a list box and the between was used as a control source
My query uses the same in the date criteria, so when I open the report
It ask me for a year then a month. Works perfect except when I try to
put the date in the report.
I have used the list box with the between date before and it
worked perfect and showed a begin date and end date, but this time
it will not work.
Thanks for any help
Roger

How did you "put it in the report header"? Do you have a control source
property you could share with us?

--
Duane Hookom
MS Access MVP
--

I have a report where I would like to have a date in the header, The
report
pulls the
data from a query with the following date criteria.
Between DateSerial([Enter Year:],[Enter Month (1-12):],1) And
DateSerial([Enter Year:],[Enter Month (1-12):]+1,0)
this works great, but when I put it in the report header so the year
and
month will
show on the report, I get a syntax error.
What am I doing wrong?
Or is there another way to get the report to show the year and month?
Thanks for any help
Roger

 

[Guest]

Hi Duane
I used a text box and put this as the control source
Between DateSerial([Enter Year:],[Enter Month (1-12):],1) And
DateSerial([Enter Year:],[Enter Month (1-12):]+1,0)
Thanks
Roger

A "list box" or a text box? I asked you previously for the Control Source
but you seemed to have ignored my question.

--
Duane Hookom
MS Access MVP

Hi Duane
Sorry about the late reply, but was called out of town.
I used a list box and the between was used as a control source
My query uses the same in the date criteria, so when I open the report
It ask me for a year then a month. Works perfect except when I try to
put the date in the report.
I have used the list box with the between date before and it
worked perfect and showed a begin date and end date, but this time
it will not work.
Thanks for any help
Roger

How did you "put it in the report header"? Do you have a control source
property you could share with us?

--
Duane Hookom
MS Access MVP
--

I have a report where I would like to have a date in the header, The
report
pulls the
data from a query with the following date criteria.
Between DateSerial([Enter Year:],[Enter Month (1-12):],1) And
DateSerial([Enter Year:],[Enter Month (1-12):]+1,0)
this works great, but when I put it in the report header so the year
and
month will
show on the report, I get a syntax error.
What am I doing wrong?
Or is there another way to get the report to show the year and month?
Thanks for any help
Roger

 

[Duane Hookom]

Try:
="Between " & DateSerial([Enter Year:],[Enter Month (1-12):],1) & " And " &
DateSerial([Enter Year:],[Enter Month (1-12):]+1,0)


--
Duane Hookom
MS Access MVP

Hi Duane
I used a text box and put this as the control source
Between DateSerial([Enter Year:],[Enter Month (1-12):],1) And
DateSerial([Enter Year:],[Enter Month (1-12):]+1,0)
Thanks
Roger

A "list box" or a text box? I asked you previously for the Control Source
but you seemed to have ignored my question.

--
Duane Hookom
MS Access MVP

Hi Duane
Sorry about the late reply, but was called out of town.
I used a list box and the between was used as a control source
My query uses the same in the date criteria, so when I open the report
It ask me for a year then a month. Works perfect except when I try to
put the date in the report.
I have used the list box with the between date before and it
worked perfect and showed a begin date and end date, but this time
it will not work.
Thanks for any help
Roger

:

How did you "put it in the report header"? Do you have a control
source
property you could share with us?

--
Duane Hookom
MS Access MVP
--

I have a report where I would like to have a date in the header, The
report
pulls the
data from a query with the following date criteria.
Between DateSerial([Enter Year:],[Enter Month (1-12):],1) And
DateSerial([Enter Year:],[Enter Month (1-12):]+1,0)
this works great, but when I put it in the report header so the year
and
month will
show on the report, I get a syntax error.
What am I doing wrong?
Or is there another way to get the report to show the year and
month?
Thanks for any help
Roger

 

[Guest]

Thanks
That worked
Roger

Try:
="Between " & DateSerial([Enter Year:],[Enter Month (1-12):],1) & " And " &
DateSerial([Enter Year:],[Enter Month (1-12):]+1,0)


--
Duane Hookom
MS Access MVP

Hi Duane
I used a text box and put this as the control source
Between DateSerial([Enter Year:],[Enter Month (1-12):],1) And
DateSerial([Enter Year:],[Enter Month (1-12):]+1,0)
Thanks
Roger

A "list box" or a text box? I asked you previously for the Control Source
but you seemed to have ignored my question.

--
Duane Hookom
MS Access MVP


Hi Duane
Sorry about the late reply, but was called out of town.
I used a list box and the between was used as a control source
My query uses the same in the date criteria, so when I open the report
It ask me for a year then a month. Works perfect except when I try to
put the date in the report.
I have used the list box with the between date before and it
worked perfect and showed a begin date and end date, but this time
it will not work.
Thanks for any help
Roger

:

How did you "put it in the report header"? Do you have a control
source
property you could share with us?

--
Duane Hookom
MS Access MVP
--

I have a report where I would like to have a date in the header, The
report
pulls the
data from a query with the following date criteria.
Between DateSerial([Enter Year:],[Enter Month (1-12):],1) And
DateSerial([Enter Year:],[Enter Month (1-12):]+1,0)
this works great, but when I put it in the report header so the year
and
month will
show on the report, I get a syntax error.
What am I doing wrong?
Or is there another way to get the report to show the year and
month?
Thanks for any help
Roger