March 3, 2011 at 8:24 am
Maybe someone here can help me out.
I have a SQL Server 2008 database with many tables. I created views for the tables to display only the info that is needed for reporting. Then I created a read-only linked MS Access 2007 database for the report developers. The developers do not have SSMS and will not get it; they are not db admins.
Now, the dates in the SQL db, are set as date fields. Using the (date,null) format, and the dates are displayed like YYYY-MM-DD. This works fine for me and whatever I need to do on the SQL server. But when the linked data shows up in MS Access, MS Access labels the date fields as text. I educated them on how to use the format function in MS Access (yeah, i know...they should already know this stuff :ermm: ) in their reporting sql statements, and that seems to be working ok...for now.
My goal, is to provide the report developers with data that they do not have to format. Just run their queries. However, whatever convert or cast functions I try to use on the SQL side, the date data still shows up as text on the MS Access side. Is there any way around this, or is MS Access just a bit retarded at times?
Thanks,
Michal
March 3, 2011 at 9:22 am
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply