By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,998 Members | 2,773 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,998 IT Pros & Developers. It's quick & easy.

Create report in MS-ACCESS

P: n/a
Hello,

I'm new in creating report in Ms-Access and I have some questions.

I want to display a text Hong Kong Dollars when a field in my database
is = "HKD" and display a text Patacas when this field is
= "MOP".

Is there possible?

I'm using Visual Basic 6 to "access" the database. Input data, read
data from the db, print the report that is made inside the
MS-ACCESS.

Can someone help me?

Cheers!

Claudia

Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
On 27 Jul 2005 21:51:17 -0700, "cd********@yahoo.co.uk"
<cd********@yahoo.co.uk> wrote:

One popular way to do that is to have a table in the database with
currencies:
ID, Abbreviation, Description
1, HKD, Hong Kong Dollars
2, USD, United States Dollars
etc.
Then you can join with that table and pick up the Description.

A quick-n-dirty version may work if you have just a few translations.
You could write an IIF statement in your query like this (assuming
your currency abbreviation field is called Access
Database Autopilot):
select field1, field2, iif(CurrAbbrev="HKD", "Hong Kong Dollars",
CurAbbrev) from myTable

So in both cases the work is done in the report's underlying query,
not in the report itself.

-Tom.

Hello,

I'm new in creating report in Ms-Access and I have some questions.

I want to display a text Hong Kong Dollars when a field in my database
is = "HKD" and display a text Patacas when this field is
= "MOP".

Is there possible?

I'm using Visual Basic 6 to "access" the database. Input data, read
data from the db, print the report that is made inside the
MS-ACCESS.

Can someone help me?

Cheers!

Claudia


Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.