Date in Report Header

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
How did you "put it in the report header"? Do you have a control source
property you could share with us?
 
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

Duane Hookom said:
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
--

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


XeniaEagle said:
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

Duane Hookom said:
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
--

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

Duane Hookom said:
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


XeniaEagle said:
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

Duane Hookom said:
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
Click to expand...
Click to expand...
Click to expand...
 
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


XeniaEagle said:
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

Duane Hookom said:
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


XeniaEagle said:
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
Click to expand...
Click to expand...
Click to expand...
 
Thanks
That worked
Roger

Duane Hookom said:
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


XeniaEagle said:
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

Duane Hookom said:
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
Click to expand...
Click to expand...
Click to expand...
 
Back
Top