What To Do When Your Value Won't Format as Currency in Microsoft Access

[@ijo680]

Cool tip .. thank you Richard!

[@599CD]

Welcome

[@stanTrX]

Thank you. How can we change th currency sign if wrie are working,say both in Euro and US dollars for instance 8:48

[@599CD]

Currency Symbols: 599cd.com/CurrencySymbols - always try a search of my website or KZbin first. You'll get an answer quicker.

[@ChekwuruiSalome-mj8qt]

Thanks 🙏,buh how do you format a value to thousands

[@michaelrstahl4195]

a+ video

[@599CD]

Thanks

[@Hrubicundus]

Does amyone else find it absolutely insane that Access can take 2 numeric fields (price and quantity), perform a mathematical operation on them (multiply them together), and return the answer as text rather than a number? What were the developers thinking ? Richard, i watched your "small tables" video. Very clever. However when I want to run a query that returns the customers and their (say) City (not City ID), it doesn't seem to work, as it doesn't return any records. Any ideas mate?

[@599CD]

Numbers as text: yeah, odd.

[@599CD]

If you mean HELPER tables, just join them together in a query

[@aisoftwaressolutions1661]

❤

[@599CD]

Thanks