First part of a field

K

Kevbro7189

I have a Text field (WUC) that contains 2 to 6 digits I want another field to
look at the [WUC] and pick out the first two digits. I.E. “567HH†would be
“56†in the new field.

The Control Source that is not working for me is
=Left$(([WUC]),2)

Any Ideas on how to fix this?
 
J

Jeff Boyce

Where are you trying to do this? In a form?

Left([AField],2) works for me in a query or in a control on a form.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
K

Kevbro7189

A form, I get a responce, but with 3200 I get as a responce 27.

Jeff Boyce said:
Where are you trying to do this? In a form?

Left([AField],2) works for me in a query or in a control on a form.

Regards

Jeff Boyce
Microsoft Office/Access MVP

Kevbro7189 said:
I have a Text field (WUC) that contains 2 to 6 digits I want another field
to
look at the [WUC] and pick out the first two digits. I.E. "567HH" would
be
"56" in the new field.

The Control Source that is not working for me is
=Left$(([WUC]),2)

Any Ideas on how to fix this?
Click to expand...
Click to expand...
 
K

KARL DEWEY

Maybe it is looking at a different record.
--
KARL DEWEY
Build a little - Test a little


Kevbro7189 said:
A form, I get a responce, but with 3200 I get as a responce 27.

Jeff Boyce said:
Where are you trying to do this? In a form?

Left([AField],2) works for me in a query or in a control on a form.

Regards

Jeff Boyce
Microsoft Office/Access MVP

Kevbro7189 said:
I have a Text field (WUC) that contains 2 to 6 digits I want another field
to
look at the [WUC] and pick out the first two digits. I.E. "567HH" would
be
"56" in the new field.

The Control Source that is not working for me is
=Left$(([WUC]),2)

Any Ideas on how to fix this?
Click to expand...
Click to expand...
Click to expand...
 
K

Kevbro7189

The form I'm using this in is showing only 1 record and when I change the 6
digit field the other field changes too.

KARL DEWEY said:
Maybe it is looking at a different record.
--
KARL DEWEY
Build a little - Test a little


Kevbro7189 said:
A form, I get a responce, but with 3200 I get as a responce 27.

Jeff Boyce said:
Where are you trying to do this? In a form?

Left([AField],2) works for me in a query or in a control on a form.

Regards

Jeff Boyce
Microsoft Office/Access MVP

I have a Text field (WUC) that contains 2 to 6 digits I want another field
to
look at the [WUC] and pick out the first two digits. I.E. "567HH" would
be
"56" in the new field.

The Control Source that is not working for me is
=Left$(([WUC]),2)

Any Ideas on how to fix this?
Click to expand...
Click to expand...
Click to expand...
 
K

KARL DEWEY

What is the record source for the form?
--
KARL DEWEY
Build a little - Test a little


Kevbro7189 said:
The form I'm using this in is showing only 1 record and when I change the 6
digit field the other field changes too.

KARL DEWEY said:
Maybe it is looking at a different record.
--
KARL DEWEY
Build a little - Test a little


Kevbro7189 said:
A form, I get a responce, but with 3200 I get as a responce 27.

:

Where are you trying to do this? In a form?

Left([AField],2) works for me in a query or in a control on a form.

Regards

Jeff Boyce
Microsoft Office/Access MVP

I have a Text field (WUC) that contains 2 to 6 digits I want another field
to
look at the [WUC] and pick out the first two digits. I.E. "567HH" would
be
"56" in the new field.

The Control Source that is not working for me is
=Left$(([WUC]),2)

Any Ideas on how to fix this?
Click to expand...
Click to expand...
Click to expand...
 
K

Kevbro7189

It's comming from a Query.

KARL DEWEY said:
What is the record source for the form?
--
KARL DEWEY
Build a little - Test a little


Kevbro7189 said:
The form I'm using this in is showing only 1 record and when I change the 6
digit field the other field changes too.

KARL DEWEY said:
Maybe it is looking at a different record.
--
KARL DEWEY
Build a little - Test a little


:

A form, I get a responce, but with 3200 I get as a responce 27.

:

Where are you trying to do this? In a form?

Left([AField],2) works for me in a query or in a control on a form.

Regards

Jeff Boyce
Microsoft Office/Access MVP

I have a Text field (WUC) that contains 2 to 6 digits I want another field
to
look at the [WUC] and pick out the first two digits. I.E. "567HH" would
be
"56" in the new field.

The Control Source that is not working for me is
=Left$(([WUC]),2)

Any Ideas on how to fix this?
Click to expand...
Click to expand...
Click to expand...
 
J

Jeff Boyce

I believe Karl was asking for you to post the SQL statement of the query...

Regards

Jeff Boyce
Microsoft Office/Access MVP


Kevbro7189 said:
It's comming from a Query.

KARL DEWEY said:
What is the record source for the form?
--
KARL DEWEY
Build a little - Test a little


Kevbro7189 said:
The form I'm using this in is showing only 1 record and when I change
the 6
digit field the other field changes too.

:

Maybe it is looking at a different record.
--
KARL DEWEY
Build a little - Test a little


:

A form, I get a responce, but with 3200 I get as a responce 27.

:

Where are you trying to do this? In a form?

Left([AField],2) works for me in a query or in a control on a
form.

Regards

Jeff Boyce
Microsoft Office/Access MVP

message
I have a Text field (WUC) that contains 2 to 6 digits I want
another field
to
look at the [WUC] and pick out the first two digits. I.E.
"567HH" would
be
"56" in the new field.

The Control Source that is not working for me is
=Left$(([WUC]),2)

Any Ideas on how to fix this?
Click to expand...
Click to expand...
Click to expand...
 
K

Kevbro7189

Where do I find that?

Jeff Boyce said:
I believe Karl was asking for you to post the SQL statement of the query...

Regards

Jeff Boyce
Microsoft Office/Access MVP


Kevbro7189 said:
It's comming from a Query.

KARL DEWEY said:
What is the record source for the form?
--
KARL DEWEY
Build a little - Test a little


:

The form I'm using this in is showing only 1 record and when I change
the 6
digit field the other field changes too.

:

Maybe it is looking at a different record.
--
KARL DEWEY
Build a little - Test a little


:

A form, I get a responce, but with 3200 I get as a responce 27.

:

Where are you trying to do this? In a form?

Left([AField],2) works for me in a query or in a control on a
form.

Regards

Jeff Boyce
Microsoft Office/Access MVP

message
I have a Text field (WUC) that contains 2 to 6 digits I want
another field
to
look at the [WUC] and pick out the first two digits. I.E.
"567HH" would
be
"56" in the new field.

The Control Source that is not working for me is
=Left$(([WUC]),2)

Any Ideas on how to fix this?
Click to expand...
Click to expand...
Click to expand...
 
K

KARL DEWEY

Open the query in design view, click on SQL View, highlight all, copy, and
paste in a post.
--
KARL DEWEY
Build a little - Test a little


Kevbro7189 said:
Where do I find that?

Jeff Boyce said:
I believe Karl was asking for you to post the SQL statement of the query...

Regards

Jeff Boyce
Microsoft Office/Access MVP


Kevbro7189 said:
It's comming from a Query.

:

What is the record source for the form?
--
KARL DEWEY
Build a little - Test a little


:

The form I'm using this in is showing only 1 record and when I change
the 6
digit field the other field changes too.

:

Maybe it is looking at a different record.
--
KARL DEWEY
Build a little - Test a little


:

A form, I get a responce, but with 3200 I get as a responce 27.

:

Where are you trying to do this? In a form?

Left([AField],2) works for me in a query or in a control on a
form.

Regards

Jeff Boyce
Microsoft Office/Access MVP

message
I have a Text field (WUC) that contains 2 to 6 digits I want
another field
to
look at the [WUC] and pick out the first two digits. I.E.
"567HH" would
be
"56" in the new field.

The Control Source that is not working for me is
=Left$(([WUC]),2)

Any Ideas on how to fix this?
Click to expand...
Click to expand...
Click to expand...
 
Top