Search results

Thanks for the help. What I am seem to be having issues with now is when I create a field for the results of my CASE statement and then want to compare them. This is what I wrote select data_collection_template.[item number (catalog)], Data_Collection_Template.[NAED / UPC Number]...

What is BOL? I had tried the CASE WHEN ..... then ...... else......end but I need to have the value go into a new field. So this statement IIf(Len([Price1])> 0,Round([Price1],2),0)AS EZViewPrice1 puts the value in the field EZVIEWPrice1. I tried adding the AS EZViewPrice1 in the CASE...

We are moving our Access dbs into SQL and trying to copy the SQL code in the queries into Access and finding there are some differences. There is one that I am stumped on. Here is part of the code. SELECT Data_Collection_Template.[Item Number (Catalog)], Data_Collection_Template.[NAED / UPC...