Search results

Hi Guys, i am changing nulls because they are not joined properly where i am doing left joins. Jacek

Hi Guys, i am using query to update nulls to "Null" string on temp table: UPDATE tblVolumeOSMountOptionsTemp SET OSType = Nz(OSType,"Null"), OSDistro = Nz(OSDistro,"Null"), OSVersion = Nz(OSVersion,"Null"), StorageProtocol = Nz(StorageProtocol,"Null"), ProtocolVersion =...

Ok Guys, i solved the problem. I have just build an Excel which is converting all field names for Nz statements.

Hi, thanks. I can not share my databse unfortunately but i will prepare example database. With temp CSV with empty table and database table where i have to check what exists or not using joins on empty fields also. Best, Jacek

hi cheekybuddha, thank you! This is exactly what i am trying to automate here - this is why i created the topic.

Hi Minty, thanks! Of course, the query from which i am struggling is: SELECT qrySource_VolumeMountOptions4.OSType, qrySource_VolumeMountOptions4.OSDistro, qrySource_VolumeMountOptions4.OSVersion, qrySource_VolumeMountOptions4.StorageProtocal, qrySource_VolumeMountOptions4.ProtocolVersion...

Hello, can anybody help? Jacek

Anyone please? Jacek

Ok, where the my issue is in detais: INSERT INTO tblTopoTierFuncVolStorageSelector ( TopologyTierFunctionIDFK, VolumeStorageSelectorIDFK ) SELECT qrySource_VolumeShareModes3.TopologyTierFunctionID, qrySource_VolumeShareModes3.VolumeStorageSelectorID FROM qrySource_VolumeShareModes3 LEFT JOIN...

You can join fields. If you have empty column with nulls you can use for example left join to check if you have to remove columns from your database. So taking raw data form CSV -->Import to Temp Table --> Checking with existing tables what should be added or deleted.Join will not work on null...

Thank you Minty! do you have maybe any example of changing datafields using VBA in Access? If i will have "Null" in tables itself i have to replace them before outputting to Nulls once again... Jacek

Hi pisorsisaac@gmail.co, i want to replace all nulls values from table columns and create query which will change them not to "" but to string "Null". Jacek

thank you Minty. This is for importing raw data into tables from csv without primary key. I have to check what was added, deleted and updated. If you have nulls join just will not work. But if you are using Nz function for nulls - join is working without any issues. So i can take null columns...

thank you Minty, this is explaining a lot. This is not what i want to do. Maybe i could have the function for writing query or something like that? Best, Jacek

cheekybudda just follow this topic. Anybody knows and can explain in simple technical English how this format is working what Is the diilfference between nz function and if this work together with joins?

And how this is working? It will be treated as string or it is just display info. In Excel when i am changing format this is only for displaying...

hmm it is better than Nz? Safe? And what about strings, dates and so on? Jacek

thank you, i wrote this topic but still i do not catch it. they are changing colors there. How this format is better than nz function? Jacek

Thank you Guys, hmm but i will use this function checkyybuddha all the time. ;;;"Null" What does it mean Arnel? This is not Nz function, it will work the same? Jacek

Hi Guys, i have a table where i have nulls. I want to for each column where i have null use Nz function in order to have result "Null" as string. Problem what i have is that i have to go manually for each column, set up Nz function and it takes a long time. It is the way to automate it...