letters in number fields

  • Thread starter Thread starter Paul Milner
  • Start date Start date
P

Paul Milner

Hi
I found that an access database field doesn't accept
text.so when I do a search on say budget amount it
returns something like
20000 when I would like it to return £20,000 or even
20,000 how can a query be set up to do this?

My present sql is

Amount_required <= ::Amount_required::)"

Best wishes
PaulM
 
Thanks
I have had to change it to a number field from a text
field because I needed to do a search on the numbers and
it didnt work properly on text. I have been looking on
the web and I think I need to insert some kind of mask
but how I don't know
Paul M
 
Leave your data type at number, and set the format of that field to what
you want, eg. "currency"
 
Hi
When I do a search it is still showing the numbers as
20000 instead of £20,000 is there anything that I might
be doing wrong I am using the database results wizard
search form.
Thanks
Paul M
 
Back
Top