No. Tables store data. Queries find it (and do calculations). Forms
display it (and do calculations). Reports display it for printing (and do
calculations).
If you were working with a heavy-duty back-end (data) tool, it might include
a way to do calculations in the tables ... but there are some really good
reasons why having calculated values in tables is not a good idea.
--
Regards
Jeff Boyce
Microsoft Office/Access MVP
http://mvp.support.microsoft.com/
Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/
Microsoft Registered Partner
https://partner.microsoft.com/
"Danni2004" <(E-Mail Removed)> wrote in message
news:FB8C20D3-2FBA-424B-85D9-(E-Mail Removed)...
> Thanks.
> Is there a way to add this "Left" calculation to a column in the table?
>
> "Jeff Boyce" wrote:
>
> > Create a new query. Add the table. Add the field (this is just to
"prove"
> > it's working). Run it.
> >
> > Add a new field, something like:
> >
> > NewField: Left([YourFieldName],3)
> >
> > Run it again.
> >
> > --
> > Regards
> >
> > Jeff Boyce
> > Microsoft Office/Access MVP
> > http://mvp.support.microsoft.com/
> >
> > Microsoft IT Academy Program Mentor
> > http://microsoftitacademy.com/
> >
> > Microsoft Registered Partner
> > https://partner.microsoft.com/
> >
> >
> > "Danni2004" <(E-Mail Removed)> wrote in message
> > news:C48D5FA9-F996-4804-A2DA-(E-Mail Removed)...
> > > I am new to Access and need assistance creating a field that can pull
the
> > > first three text digits of another field. I've tried to do this in the
> > table
> > > and in a query without success. I found the "left" expression in the
> > > expression builder but haven't been able to make it work for me.
> > > For example, the record has a field the says "PTO35712" and I just
need
> > the
> > > "PTO" part.
> > > Can anyone help please?
> > >
> > > Thanks in advance!
> >
> >
Similar Threads
