Record with multiple lines

So learning from the help i've gotten previously I've applied it to my
current situation, but now I've run into another road block.

Here's a sample of my table history (some fields just omitted for sake)
Countries (table)
Country_ID(PK)
Region_ID(FK)
Country
ISO_Code
Support_ID(FK)

tbl_supportdetails
Support_ID(PK)
email address
phone
fax

currencies
Currency_ID(PK)
Currency

tbl_currencybridge
UniqueID (PK)
Currency_ID(FK)
Country_ID(FK)

A country can be invoiced in many currencies and a currency can be tied to
many countries (the many to many relationship). Here's my problem: For
example, Albania invoices in USD and Euro which is showing two separate rows.
In my report I'll need it to show all currencies in one line item.

here is my sql statement (want it to show all countries regardless of
whether or not a currency is tied)
SELECT GlobalZoneTable.Country_ID, GlobalZoneTable.Country,
GlobalZoneTable.[serviced out of], GlobalZoneTable.[email Address],
GlobalZoneTable.[Local Freephone], GlobalZoneTable.[calling from abroad],
GlobalZoneTable.[Local Freefax], GlobalZoneTable.[sending a fax from abroad],
[tbl_currencybridge Query].Currency
FROM GlobalZoneTable LEFT OUTER JOIN [tbl_currencybridge Query] ON
GlobalZoneTable.Country_ID = [tbl_currencybridge Query].Country_ID;

So in my report I create a textbox b/c I want this data all in one field per
country
=([serviced out of])+Chr(13)+Chr(10) & ([email Address]+Chr(13)+Chr(10)) &
([Local Freephone]+Chr(13)+Chr(10)) & ([calling from abroad]+Chr(13)+Chr(10))
& ([Local Freefax]+Chr(13)+Chr(10)) & ([sending a fax from
abroad]+Chr(13)+Chr(10)) & ([Currency]+Chr(13)+Chr(10))
Again it's showing multiple entries for countries that have more than one
currency; whereas ideally it just would list all the currencies on one line
in the report.

Another workaround i thought was to put the currency textbox in the detail
section and put the above wrapping (minus currency) in the country
header...this results in the currencies being together, but not on the same
line, rather a listing (top to bottom).

Thanks for the help once again.
.

Relevant Pages

  • The Case for Fewer but Stronger Currencies
    ... The Case for Fewer but Stronger Currencies ... OUTSOURCING isn't just a one-way street on which rich countries shift ... monetary policy - known as dollarization, ... professor of economics at New York University's Stern School ...
    (soc.culture.indian)
  • RE: Record with multiple lines
    ... A country can be invoiced in many currencies and a currency can be tied to ... many countries. ... In my report I'll need it to show all currencies in one line item. ... So in my report I create a textbox b/c I want this data all in one field per ...
    (microsoft.public.access.queries)
  • Re: Wholesale Inflation Rate Soars
    ... :>no. they inflate their currencies so that their products are not priced ... I wasn't aware other countries were inflating their currencies - it ... I wish the other countries would inflate ... everybody who has assets in cash is ...
    (soc.retirement)
  • Re: Invoice with two currencies`
    ... Some companies offer a hint in other currencies, ... As to Europe: ... There are 25 countries in the EU. ... Invoicing system based on dollars. ...
    (comp.databases.filemaker)
  • Re: What could China do to the American economy if they traded their dollars for Euros?
    ... dumping dollars, the dollar loses value vs. other currencies, so other ... the market reaches a new equilibrium. ... US dollar has been artificially kept high by Chinese crediting us and buying ... large countries. ...
    (sci.econ)