MS SQL datetime field in access report

  • Thread starter Thread starter Alan
  • Start date Start date
A

Alan

When trying to display a date field in an access report
not all of the dates are showing on the report. When the
stored proc (which is the record source for the report) is
executed in query analyzer all the dates are shown as
expected. When the access report is run, not all of the
dates that were returned in qa show up. Any thoughts or
ideas would be greatly appreciated. Also, tried different
format options on the date column in access but no luck.
 
Alan:

When you say the dates are not showing up, do you mean that the sproc is not
returning all the records you would expect in the report or, that all the
row data displays, but you are not seeing the value of the data in the
control that is bound to the returned date field?

If the latter, then what SQL format are you using for the date field (i.e.
using a cast or convert statement in the sproc)?
 
sproc returns all the records as expected, but the text
box on the report does not show all of the records
returned. I cast the date field to small datetime and
still do not get all records when the report is run.
Thanks for the help.
 
Back
Top