Access DB Dates

[funkmonsteruk]

I'm having a few problems with a Business Objects report that i've hooked up to an access database. The report has a time condition appled to it, but when i compare my results from BO to the ones i'm getting from access using an identical query the Access query is giving me higher figures.

Has anybody had a similar problem before?

I thought that if i created a date object in the universe date(variable) that this would solve the problem - but when i parse the new object i'm getting an error.... AAArrrgggghhhhhh

 

[pabloj]

Check SQL generated by BO for differences ... Stick to your guns

 

[blom0344]

Depends on how you define similar queries......
If you are not using pass-through queries in Access you are using the Jet-SQL (Microsoft)syntax to work on a specific database. Business Objects uses the SQL syntax that the database uses, because in the universe connection you specify the type of database you are going to connect to.
So take the SQL that Business Objects generates and use this literally in a pass-through query in Acces. (Do not use prompts) See if you have differences still......... T. Blom
Information analyst
tbl@shimano-eu.com