Information générale
Titre:
Data types in query results - funny characters
I have queries used for graphs that look like SELECT datefield, Null AS somenumber, someothernumber FROM somequery UNION SELECT datefield, somenumber, Null AS someothernumber FROM someotherquery. It worked in Access 97, but in Access 2002 the fields that have Null for the first part of the query are showing Kanji characters (or something like that) in the datasheet and not working. I figure that the nulls are messing up the datatype. My workaround is to tack on another query in front of it, like this: SELECT Null AS datefield, 0 AS somenumber, 0 AS someothernumber FROM dummyquery UNION ...all of the above. The Null in the date field doesn't seem to matter. If it did, I'd be screwed, because the date field is the x-axis and I mustn't confuse Microsoft Graph. But I was hoping for a workaround that didn't involve tacking a UNION clause in front of all the queries that look like this. Anything better?
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement