Changing letters to numbers

  • Thread starter Thread starter Tracy
  • Start date Start date
T

Tracy

I have a column that stores customer terms like this:
net 30 days
net 60 days
net 90 days, etc.

I need to figure when an invoice is due based on the order
date and the customers terms.

Can I write an if statement that says if that column = net
30 days then substitute just the number 30, or 60 or
whatever so that I can then perform my date calculation?

Thanks in advance
Tracy
 
Don't store this as text. Use a field named [NetDays] and store only the
number of days. You can then use simple date functions.
 
Thank you for the response.

This is not a database I have set up. I am trying to
write reports from and existing database. Anything else I
can try?

Tracy

-----Original Message-----
Don't store this as text. Use a field named [NetDays] and store only the
number of days. You can then use simple date functions.

--
Duane Hookom
MS Access MVP


I have a column that stores customer terms like this:
net 30 days
net 60 days
net 90 days, etc.

I need to figure when an invoice is due based on the order
date and the customers terms.

Can I write an if statement that says if that column = net
30 days then substitute just the number 30, or 60 or
whatever so that I can then perform my date calculation?

Thanks in advance
Tracy
Click to expand...


.
Click to expand...
 
If all of your field values begin with "Net " then you can use
Val(Mid([CustTerms],4))

--
Duane Hookom
MS Access MVP


Tracy said:
Thank you for the response.

This is not a database I have set up. I am trying to
write reports from and existing database. Anything else I
can try?

Tracy

-----Original Message-----
Don't store this as text. Use a field named [NetDays] and store only the
number of days. You can then use simple date functions.

--
Duane Hookom
MS Access MVP


I have a column that stores customer terms like this:
net 30 days
net 60 days
net 90 days, etc.

I need to figure when an invoice is due based on the order
date and the customers terms.

Can I write an if statement that says if that column = net
30 days then substitute just the number 30, or 60 or
whatever so that I can then perform my date calculation?

Thanks in advance
Tracy
Click to expand...


.
Click to expand...
Click to expand...
 
Thank you! That worked great.
-----Original Message-----
If all of your field values begin with "Net " then you can use
Val(Mid([CustTerms],4))

--
Duane Hookom
MS Access MVP


Thank you for the response.

This is not a database I have set up. I am trying to
write reports from and existing database. Anything else I
can try?

Tracy

-----Original Message-----
Don't store this as text. Use a field named [NetDays]
Click to expand...
and
store only the
number of days. You can then use simple date functions.

--
Duane Hookom
MS Access MVP


I have a column that stores customer terms like this:
net 30 days
net 60 days
net 90 days, etc.

I need to figure when an invoice is due based on the order
date and the customers terms.

Can I write an if statement that says if that column
Click to expand...
=
net
30 days then substitute just the number 30, or 60 or
whatever so that I can then perform my date calculation?

Thanks in advance
Tracy


.
Click to expand...
Click to expand...


.
Click to expand...
 
Back
Top