Search results

Thanks for your expert eyes to spot out the data entry error. Missing comma in data will halt program running. What else?. Is it possible to show error in the result where contains erratum data? It is more easier to spot the error. What sort of data validation I must check to ensure the...

Hi arnelgp, Following your instructions, I created another query with true data. However when I ran it, it showed an error message "Run-time error '9': Subscript out of range". Upon checking the statement, I did not find any errors.:confused: Could you please help see if my modifications fit...

Thanks for your further advice and will try it on.:)

Hi arnelgp, following your instructions, I made it work correctly with my sample file. Thanks a lot! I would like to apply to my database that has 14 fields instead of 4 fields. How can I extend your code to 14 fields?

Sorry for confused data in my early message. My table has been stripped down after I submitted the message. Now I attach a excel table for easier understanding.

Sorry for my unclear examples. They should look as below:- Co SKU Model Incharge Co A 123456, 234567 AM12345, BM12345 JB Co B 345678, 456789 CM45678, DM738738 KL Co C 567890 EM78968 MM...

I have a table consisting multi items in two fields and looking for a way to break them into individual records. They look something like following example. Co A 123456, 234567 AM12345, BM12345 JB Co B 345678, 456789 CM45678, DM738738 KL Co C 567890...

I attached a sample file for illustration of the issue. The raw data part consists of 5 columns. Using consolidate function to accomplish the task by using SKU and QYT columns only. However I need to output the report together with Supplier and Cat columns. How can I alter the consolidate...

Can the consolidate function be used with more than 2 columns. I would like to have the results with other relevant columns, not just the column to determine duplicates and other one with values to be summed up. If so, your guidance pls.

It sounds strange for IIf function to follow the list separator. May I check other users machines to determine which setting should go. Anyway appreciate your guidance.

You are right the list separator is semicolon. Should I change it to comma inline with a setting of most users - what is best setting as the program may be used for a number of users. I was not aware of it - we do not use comma instead of decimal like German.

Fantastic, it works with semicolons instead. Could you please share what cause it with regional settings.

The hyphen is not the syntax breaker. I tried to remove the Or part with the same error.:confused:

Tried it without success. Error message was same and the pointer stopped at the first comma. The data types are number as attached image. Very strange error!

Both fields are numeric type but only small percentage (20%) contain data.

No luck and error remains. R-NoofBatt is another field, not spelling error. I tried NoofBatt field first with the same error and then added on the second field.

I have following calculated field in a query and returned with an error. I double checked the syntax and found nothing wrong. Did I overlook something? You help is appreciated.:confused: BattCheck: IIf([NoofBatt]<1 Or [R-NoofBatt] <1,"No","Yes") The expression you entered contains invalid...

Let me try to see any benefit with this alternative! Thanks for your sharing.

Thanks for your further advice! Now is fine.

Your trick works well and appreciated! Thanks! The multiple skus may not fit in this way and required other way to handle.