Deleting certain data

[swindmiller]

I am not even sure what I need but I have a table that has data that looks like: Data1_Data2.Data3 in a certain field. I am importing this data from another DB and want to remove everything after the "_".



Would this be a query and how would I do it?


Thanks,
Scott

[pbaldy]

You can use the Left() function along with the InStr() function to find the position of the underscore. You can either display the revised data that way in a query/form/report, or actually change the stored data with an UPDATE query. Have a look at those in help and see how it goes. Post back if you get stuck.

[swindmiller]

Thanks for the push in the right direction.

The field name I am using is: Home Directory_Volume

So I tried: Left([Home Directory_Volume],(InStr(1,[Home Directory_Volume],"_")-1)) to try to get everything before the _and I get a Data Type Mismatch.

What am I doing wrong.

[pbaldy]

I'm not sure. Just did a brief test and it worked as expected. Can you post the db?