EXPIRED

CALLING ALL MS ACCESS EXPERTS!!!!!!!!!!!!!!!!!!!!!!

Hi all,

I'm hoping HUKD can come to my rescue. I am currently working on a project in MS Access, and I have worked out the difference between two colums. But in the query i want it to show the £ sign infront of the results. Anyone know how to do this???

Thanks

3 Comments

Been a while since I've touched access, can't you append the pound sign to the computed column ?

select '£' + column_a from ....

Original Poster

got it. Thanks for your helo. But its actually just in the properties part of the query

did you change the data type to currency?

Edit: you got it, nice one
Post a comment
Avatar
@
    Text
    Top Discussions
    1. Just heard this...2 ★★★★★★★★★★★★★★ congrats to all on 392k ★★★★★★★★★★★★★★7764034
    2. PS4 Beta Software Version 534
    3. Pink Balls11
    4. What's you favourite 60s 70s 80s song ?963003

    See more discussions