Format

  • Thread starter Thread starter Pass-the-reality
  • Start date Start date
P

Pass-the-reality

I am linked to someone elses database and they have a field listed as a
number. In my query, how do I convert their number field to a text field. I
got this much so far AgentSSN: Format([TAX_NBR]," but not sure what else I
need
 
Pass-the-Reality,

Not sure I understand...

In a query changing it to text is just for appearence. If you want change
the data type of the field you would need to do this in the table. HOWEVER,
if the person who wrote it created any statements using that field you will
cause a problem as certain queries, code, etc... may no longer work and
cause you REAL issues down the road... think of dominos!

If you are just trying to format the field to look like a tax number then
use AgentSSN: Format([TAX_NBR],"00-000000") <--- better count those not
sure.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index.htm
 
Pass-the-reality said:
I am linked to someone elses database and they have a field listed as a
number. In my query, how do I convert their number field to a text field.
I
got this much so far AgentSSN: Format([TAX_NBR]," but not sure what else
I
need
Click to expand...
 
Back
Top