since i'm in a query, i figured out that i don't need the actual table name, just the field name:
LastName: Left([name],InStr([name],",")-1) - this worked great to get the last name.
FirstName: Right([name],InStr([name],",")+2) - this didn't work at all...:confused:
it's not giving me any data...