letters in number fields

[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

 

[Clark]

Open the table in Design View and change the data type for that field to
text.

 

[Guest]

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

 

[Clark]

Leave your data type at number, and set the format of that field to what
you want, eg. "currency"

 

[Paul Milner]

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

 

[Kathleen Anderson [MVP - FrontPage]]

You need to tweak your SQL statement - here's how:
http://www.interlacken.com/winnt/tips/tipshow.aspx?tip=55