code in the field does not return all of the data I need 1

[smuthcrmnl777]

Left([sid1],InStr([sid1],'/')-1)

If I place this in a query as the field, this command only looks for data that has the '/'. I need to grab this and all of the rest of the data.

Currently, the results are
11-100 from 11-100/F

I need this and the other result.
11-100 from 11-100/F
11-100 from 11-100

How can I get this? Is there a simple IIF statement I could plug into the field command?

 

[SkipVought]

Hi,
[tt]
iif(InStr([sid1],'/')>0,Left([sid1],InStr([sid1],'/')-1),[sid1])
[/tt]


Skip,

_{[red]Be Advised![/red] For those this winter, caught in Arctic-like calamity, be consoled...
Many are cold, but few are frozen!}