Create report in MS-ACCESS

[cdolphin88]

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

[Tom van Stiphout]

On 27 Jul 2005 21:51:17 -0700, "cd********@yah oo.co.uk"
<cd********@yah oo.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