CALLING ALL MS ACCESS EXPERTS!!!!!!!!!!!!!!!!!!!!!! - HotUKDeals
We use cookie files to improve site functionality and personalisation. By continuing to use HotUKDeals, you accept our cookie and privacy policy.
Get the HotUKDeals app free at Google Play

Search Error

An error occurred when searching, please try again!

Login / Sign UpSubmit
Expired

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

£0.00 @
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 £ … Read More
Abz Avatar
8y, 1m agoPosted 8 years, 1 month ago
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
Tags:
Abz Avatar
8y, 1m agoPosted 8 years, 1 month ago
Options

All Comments

(3) Jump to unreadPost a comment
Comments/page:
1 Like #1
Been a while since I've touched access, can't you append the pound sign to the computed column ?

select '£' + column_a from ....
#2
got it. Thanks for your helo. But its actually just in the properties part of the query :S
#3
did you change the data type to currency?

Edit: you got it, nice one :)

Post a Comment

You don't need an account to leave a comment. Just enter your email address. We'll keep it private.

...OR log in with your social account

...OR comment using your social account

Thanks for your comment! Keep it up!
We just need to have a quick look and it will be live soon.
The community is happy to hear your opinion! Keep contributing!