Extract numbers

  • Thread starter Thread starter Pietro
  • Start date Start date
P

Pietro

Hi,
I have a field in my database where it's written "1d" or "12d" ecc..
I want to use an equation in a query to display the number included in this
field only,meaning another field where it's written "1" or "12"
how can i do this ?
 
KARL's solution is correct but it is a violation of first normal form to
store multiple attributes in a single column. You are better off splitting
this field into two columns if possible.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

1d 2h 3m 3
Extracting the few letters after the comma 5
Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1
Extract numbers 9
Automatic number combination 2
Sort 1
extract date from text field 1
Change a text field (YYYYMM) to a date value 2

Back
Top