467,119 Members | 1,180 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,119 developers. It's quick & easy.

Create report in MS-ACCESS

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
  • viewed: 1255
Share:
1 Reply
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.

Similar topics

reply views Thread by Chris | last post: by
1 post views Thread by PlumeProg | last post: by
2 posts views Thread by Dave McKie | last post: by
9 posts views Thread by itmags@gmail.com | last post: by
11 posts views Thread by Ryan | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.