Thanks for your reply.
Essentially what I want to do is change a field called period in my access table. Period is text field that shows the week of sales and if the sales figure is for the current week or the whole month. For example, last week, I will have multiple rows in the table with
I have written expressions that convert Period into 'Type' that captures the CW/STUB and 'Final' that stores this date as a British date with zeroes. i.e 25/01/2013
I have attached a qlikview and an excel file with these sort of dates. My expressions work perfectly when i load from excel. (See script and attached qlikview file)
It would be fantastic if i could use the same expressions but just load the table from access instead
Thanks for that.
Once again, it does not Load when i try it with my access table.
Can you show me the remaining part of the code,i.e with the Load and select and connect statements?
My problem IS NOT the expression, that works fine for me. It is the fact that when i try it with an ACCESS table it gives me an error on reloading.
ODBC CONNECT TO [Odonto;DBQ=C:\Users\MATest1.mdb];
if(left(FOTO_DESCRIPCION,4)='STUB',subfield(FOTO_DESCRIPCION,' ',2))) as FINAL,
if(left(FOTO_DESCRIPCION,4)='STUB',subfield(FOTO_DESCRIPCION,' ',1))) as TYPE,
SQL SELECT `FOTO_DESCRIPCION`,
FROM `B_PACI_ FOTOS`;
FOTO_DESCRIPCION is the same to period for you. to me it works.
hope now help you