Oops, didn't notice this brand new forum was here until I posted over in the server forum. So please pardon the following duplicate / cross-post:

I am trying to do a custom report in Access from the raw Kaseya data, and I need a function that will extract the group from the Machine_GroupID field. For example:

function(machine1.group1)= group1

function(machine2.group1) = group1

function(m1.longgroupname1) = longgroupname1

Because there's no fixed length to the machine or group name, I can't just trim the first or last n characters from the string. I'm sure there's an easy way to say "give me everything to the right of the period," but after searching through Access help I've come up empty so far.

Anyone know how to do this?



Legacy Forum Name: Need SQL function help,
Legacy Posted By Username: David_Schrag