Concatenate and delete characters in Query

[Ghoztrider]

I want to set up a calculated field in one of my queries. I need to concatenate characters to the beginning and end of my chosen field, this part I know how to do. What has me stumped is how do I remove a certain character. Here is what I have:

Type: "C.REGT.000" & [table1]![Field1] & "L - (Straight Time)"

I want to remove the last character of "Field1". Thank you.

 

[DCrake]

Left([table1]![Field1],Len([table1]![Field1])-1)

 

[Ghoztrider]

Wow, quick response...thank you. Does that go in the critirea portion of my calculated field or used in conjuction with the concatenated string I inserted into the calculated field?

 

[DCrake]

used in conjuction with the concatenated string

 

[Ghoztrider]

I cannot for the life of me figure out how to put these two together in one calculated field.

Type: "C.REGT.000" & [table1]![Field1] & "L - (Straight Time)"

Left([table1]![Field1],Len([table1]![Field1])-1)

 

[boblarson]

How about:

Type: "C.REGT.000" & Left([table1]![Field1],Len([table1]![Field1])-1) & "L - (Straight Time)"