Entering a Formula

[Guest]

I have no experience w/ Access.

I need to enter this formula into a new field but do not know how. Could
someone walk me through it.

Mid(yourfield,5,2)

Thank you in advance.

 

[Lynn Trapp]

Carl,
Are you trying to do that in a table? If so, it won't work. You can use that
function in a query, form, report, or in VBA code.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Access Junkie List:
http://home.bendbroadband.com/conradsystems/accessjunkie.html

 

[Joseph Meehan]

I have no experience w/ Access.

I need to enter this formula into a new field but do not know how.
Could someone walk me through it.

Mid(yourfield,5,2)

Thank you in advance.

Assuming you want to do this in a table, you would begin by making the
filed in the table description then use your formula in an update query to
place the results in the table.

The problem with that is you should not normally store the results of a
calculation in a table. You are usually better off just using a simple
query to make a temporary field each time you need the result. Stored
results may slow down Access and most importantly they don't change if you
change the data from which they were originally computed.

 

[Guest]

Thank you. How do I set-up a simple query to create the temporary field ?

 

[Joseph Meehan]

Thank you. How do I set-up a simple query to create the temporary
field ?

Create a "Select" query. Base it on the table in question. Chose the *
to put all the fields into the query. Go to the first empty filed and type
in:

NEWNAME: Mid(yourfield,5,2)

When you run the query or use it as a source for a report, form or other
queries, it will appear as if there is a filed called NEWNAME in the table.