This is my second post for the same question, hope this time I did explain more clearly about my problem.
I need a report that generate the total value of projects from a few foreign currency to USD.
In report detail section:
-2 textboxes bound to CURRENCY and CValue from a query.
-Another 2 textboxes (unbound control) -> txtRate and txtUSD
CURRENCY CValue Rate Value(USD)
txtCurr txtCValue txtRate txtUSD
-users need to key in the conversion rate in txtRate.
-txtUSD used to calculate the converted value, where i set its control source to =[CValue]*[txtRate]
In report footer:
-another textbox txtTotalUSD is created, its control source set to Sum([CValue]*[txtRate]), but it wouldn't work and keep prompt me to enter value in txtRate.Sum only work for the fields from query/table, but it did not work for unbound value/calculated value.
Is there a way to get the total amount for USD from the unbound field in report detail? Please advise me on this, thank you very much.
Beemomo
4  3506  nico5038 3,080
Recognized Expert Specialist
You can't type in fields in a report.
In this case I would create a conversion rate table and make sure that all used currency codes are present for the required report. When missing, jump to the currency code table instead of showing the report.
For the report you can join the tblCurrencyCode Rate to calculate the USD price.
One other consideration should be the use of a currency date, as they can differ over time....
Nic;o)
@nico5038
Hi Nic;o),
Thank you so much for your advise. Yup, you are right, and also the unbound text box of txtRate is not working properly in report as in it works in form. Store the currency value in another table will be the solution.
Regards,
Beemomo
nico5038 3,080
Recognized Expert Specialist
Glad I could help and success with your aplication !
Nic;o)
ur data comes from query. u can make calculation field in query and then make bound control to that calculated field in ur report. then u can take sum
Sign in to post your reply or Sign up for a free account.
Similar topics | |
by: L Mehl |
last post by:
Different users of the app will want or not want to see report footer (
appears as a separate page).
I can make the section invisible with a DLookup of a Y or N value from a
'parameters' table
Private Sub ReportFooter_Format(Cancel As Integer, FormatCount As Integer)
Reports!rptValuationDetail.Section(acFooter).Visible = _
DLookup("", "sysparms", " = " & Chr(34) &
"printReportGrandTot" & Chr(34)) = "Y"
|
by: Galina |
last post by:
Hello
I have a report, which lists records. Each record has money paid
field. Money paid can be 0 or not 0. I calculate and print summary of
money for a group in the group footer, as well as summary of money for
all groups the report footer. When there is at least one record with
money >0, group and report footers are appropriate and look OK.
When all records are with 0 money, footers look silly. I’d like
not to print them. I have placed...
|
by: Mike MacSween |
last post by:
I have a report based on:
PARAMETERS Forms!frmProductions!ProdID Long;
SELECT Sum(qryRoleEvent.Fee) AS SumOfFee, First(qryMusician.LastName) AS
LastName, First(qryMusician.FirstName) AS FirstName
FROM (qryEvent INNER JOIN qryRoleEvent ON qryEvent.EventID =
qryRoleEvent.EventID) INNER JOIN qryMusician ON qryRoleEvent.MusoID =
qryMusician.MusoID
WHERE (((qryEvent.ProdID)=!!))
GROUP BY qryMusician.MusoID
|
by: Roger |
last post by:
I've got a continuous form based on a query
the first 2 controls on the form are bound to columns in the query
a third control (paymentAmount) is unbound
I have a total control in the footer, where the control source is
=sum(paymentAmount)
this displays #Error#
but if I temporarily change my query to add a paymentAmount column
|
by: scott_baird |
last post by:
Probably something simple, but it's driving me up the wall...
In a report, I have an unbound control that is the total of 2 other
bound controls (currency) as follows:
unbound control =cash1 + cash2
However, it is possible that either cash1 or cash2 can be null, in
which case the unbound control displays nothing (apparently, addition
only works with a zero or above). What I want to do is something along
| | |
by: Greg |
last post by:
Most suggestions on this topic recommend to use a page footer and make
it visible only on the last page. My problem is that the footer is half
of the height of a page which means the detail would show on only the
top half of each page with whitepace at the bottom of each page.
How can I get the detail to fill each page with my "half page height"
report footer at the bottom of the last page?
Any suggestions to solve this would be...
|
by: Fred's |
last post by:
Hi Folks,
I have a report which the record source is a query name: Query3 and in
my Query3 I have this parameter "between And ".
Therefore, when I open my report, it will ask for a Start Date And an
EndDate.
Now I will like to have this date in the report footer of my acess
report.
|
by: D Giles |
last post by:
Access 2003: A subreport control (sum total calculated textbox located in the subreport report footer) does not show total of all records when referenced as a total in the main report footer - only shows one record amount. When I open the subreport alone, it totals the sum of all the records which the query pulls - which is what I want. The referenced textbox in the main report footer only shows one record amount. Why is the total in the main...
|
by: John McAtee |
last post by:
I am using Access 2007. Created a contribution database for a non-profit. Created parameter query that displays contributions for a specified time period using the "Between And " parameter. The query sorts by company then last name. Created a report that uses the query as the data source. Displays data per the query. When I put an unbound control in the Report Footer or Header to count the number of contributions the names get sorted by...
|
by: beemomo |
last post by:
I need a report that generate the total value of project from a few foreign currency to USD.
In report detail section:
There are 2 fields (CURRENCY,CurrValue) from query table which are displayed in bound control (text box)
To convert to value in USD, I have created a text box txtConRate, where users need to key in the conversion rate. Then there is another text box (txtValueinUSD)to calculate the converted value, where i set its control...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
| | |
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| | |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
