<div>
<div class="content wysiwyg-content">
Hi<br />
<br />
I would like to create a query to delete the letter F from my data, so that I am just left with the figures minus the F. Eg, 11/2F would become 11/2.<br />
<br />
The F only appears in some of the data, the length can vary between 3 and 5 characters and the F always appears at the end.<br />
<br />
Any ideas?
</div>
</div>


Hi

I would like to create a query to delete the letter F from my data, so that I am just left with the figures minus the F. Eg, 11/2F would become 11/2.

The F only appears in some of the data, the length can vary between 3 and 5 characters and the F always appears at the end.

Any ideas?

Delete a letter from my data via a query in MS Access

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.