How do I make a table that will truncate my data field?

[Guest]

I have a field "0002222 Catheter". I need to create a table that just pulls
out the 2222. I thought I could truncate somehow?

 

[Allen Browne]

If the numbers are always first, create a query, and type this into the
field row:
Val(Nz([F1], "0"))

After verifying that this give the right results, you can turn it into a
Make Table query, along with the other fields you want. Make Table is on the
Query menu, in query design view.

 

[Guest]

Allen,
1) Do I put in the criteria or field?
2) It is asking for a value for F1.

I am wondering why I can't use Left[fieldname},3) to get to the 2222
portion. Then use a right funtion to get rid of the words?

I do not understand how your expression works, so trying to keep simple.
Thanks for the feedback!
D

If the numbers are always first, create a query, and type this into the
field row:
Val(Nz([F1], "0"))

After verifying that this give the right results, you can turn it into a
Make Table query, along with the other fields you want. Make Table is on the
Query menu, in query design view.

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

I have a field "0002222 Catheter". I need to create a table that just pulls
out the 2222. I thought I could truncate somehow?

 

[Allen Browne]

Sorry: F1 was an example for your field name.
Substituate your field name.

Left([F1],3) would just give you the 3 zero's, I think?

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

Allen,
1) Do I put in the criteria or field?
2) It is asking for a value for F1.

I am wondering why I can't use Left[fieldname},3) to get to the 2222
portion. Then use a right funtion to get rid of the words?

I do not understand how your expression works, so trying to keep simple.
Thanks for the feedback!
D

If the numbers are always first, create a query, and type this into the
field row:
Val(Nz([F1], "0"))

After verifying that this give the right results, you can turn it into a
Make Table query, along with the other fields you want. Make Table is on
the
Query menu, in query design view.

I have a field "0002222 Catheter". I need to create a table that just
pulls
out the 2222. I thought I could truncate somehow?