P
prentice
Guest
i am querying data in MS access from an external ODBC database, unfortunately two "numeric" fields i need to link to filter data have got different properties, one is set as numeric the other is set as text and i cannot amend the properties of either. i had managed to overcome this problem by converting the "text" version using "MACRUNMODE:Nz([COSTMACH]![MACRUNMODE],0)".
although this works fine within Access the problem comes when i try to link to this Query using Excel MS Query , it says it cannot connect because excel doesnt recognise the function "Nz", conversly Access doesnt recognise Excels "N" function...... any suggestions how i overcome this
although this works fine within Access the problem comes when i try to link to this Query using Excel MS Query , it says it cannot connect because excel doesnt recognise the function "Nz", conversly Access doesnt recognise Excels "N" function...... any suggestions how i overcome this
Ken
