"Trimming down" the name field?

[brownk]

Hello everyone! In my database i have a field that contains the username of whoever entered the data. It is listed as THISNAME/FirstnameLastname. What could i do to get the query to return only the FirstnameLastname and ignore the THISNAME/ ?


Thanks

[June7]

Use string manipulation functions. Will there always be the one slash character?

Mid([fieldname],InStr([fieldname],"/")+1)

[brownk]

Yes, It will always be in that format

[June7]

Did it work?

[brownk]

No it returns everything

[June7]

It is returning the full string? Show your attempted query sql statement. Provide sample of actual data.

[brownk]

Mid([firstLast],InStr([firstLast],"/")+1) This is within the criteria field. It returns THISNAME/FirstnameLastname

[June7]

The expression is intended to be in the Field row to create a field. Then you can apply criteria to that constructed field.

[brownk]

Its now in the field row and still returning the same results.

[June7]

Show the sql statement for analysis.

[brownk]

Mid([firstLast],InStr([firstLast],"/")+1) AS [First Last]

[June7]

The query looks fine. Are you saying that the constructed field [Primary Officer] does not show FirstnameLastname part extracted from the original string?

I tested the string manipulation functions on a string with the example structure and it does work.

If you still need help I will have to analyse the project. Follow instructions at bottom of my post.

[brownk]

Yes the full field still shows. It does not extract the FirstnameLastname part.

[June7]

I have no explanation for why that isn't working. As stated, will have to review project and data directly if you want to provide.

[Gary Frazier]

Yes the full field still shows. It does not extract the FirstnameLastname part.

This is just a suggestion as to how I do it. I capture their log in when they add an entry into the database. Sometimes it is good to know who did what.
Add 2 fields to your table
CreatedByUser Text
CreatedDate Date/Time


Copy this in a module
I named mine this
Module name (basMyEmpID ) Module
Option Explicit
Option Compare Database
Public lngMyEmpID As Long

Add the fields anywhere on your form
And put this in the forms Load event
This is just a suggestion as to how I do it. I capture their log in when they add an entry into the database. Sometimes it is good to know who did what.
Add 2 fields to your table
CreatedByUser Text
CreatedDate Date/Time


Copy this in a module
I named mine this
Module name (basMyEmpID ) Module
Option Explicit
Option Compare Database
Public lngMyEmpID As Long

Add the fields anywhere on your form
And put this in the forms Load event
Private Sub Form_Load()
Me!CreatedByUser = Environ("username")
Me!CreatedDate = Now
End Sub

It saves back to the database.
Just a suggestion!!!


Private Sub Form_Load()
Me!CreatedByUser = Environ("username")
Me!CreatedDate = Now
End Sub

It saves back to the database.
Just a suggestion!!!