Reports :: Currency Symbol - Print Dollar Sign In Front Of Amount
Jan 16, 2014
I have several reports where the currency was always reported in dollars so for the fields in question I had a format of $#,###.00 which printed the dollar sign in front of the amount.
As the system has now become more sophisticated I need to print out a currency symbol depending upon the client. I have a currency table that links into the client so my query 'behind' the report holds the right symbol but how do I get it ito the report. I Know I can define a second field that will hold the symbol but to me this is a clumsy way of doing it. Is there anyway I can put the symbol in the control source for the data or into the format of the field or some other way?
I need to have a textbox formatted to have 2 decimals. If I take general number and set the decimal to 2 it will display numbers like 89.1. I would need it to be 89.10. I would like not to use the currency format as it puts the $ symbol in the textbox as well. So basically same formatting as currency (because it's a currency I am working with) but without the symbol.
I have a problem displaying the £ sign in my query. Instead of the query displaying £448.87 it displays 448.87.
You can see from the below image that the value of AllCost is £448.87 and I don't understand why its displaying 448.87 when I run the other query called All Cost 2. The Nz function is used to display £0.00 if the AllCost field is null.
How do you make the amount in a currency text box appear red if its negative? Right now it shows in parenthesis but I would like it to be red as well. Is this possible? It's also a calculated text box if that makes a difference.
My teacher instructs me to make a 'multiple item form' in regards to signing in and signing out of a dentist ( my scenario)...The fields i have are : Appointment ID, dentistID, Appointment time, Appointment Date and customerID..i have created have the multiple item form and i am now displayed with the fields.
I'm trying to create a report for my organization that sums the amount of material used by date. For example, I have five separate locations in my organization that all consume the same material. It gets reported separately by location. I need to know the total material consumed each day. Then I need to sort that daily total from largest to smallest quantity used. I've tried to do it in a query, and also by summing/grouping in a report. I thought this would be fairly straight forward, but no success as yet.
I have an unbound form with an associated report. When the user hits the 'print' button on the form/screen, the report is launched in the background. In the On Load event of the report I populate the report fields from the forms field as so:
This works like a charm as long as I call the report in Print Preview mode (i.e. with acViewPreview). But if I send the report directly to the printer, none of the fields print.
I've read about using other report events to populate the fields (e.g., On Format and On Print) and also something about using TempVars to pass the data. But I haven't read anything that's clear and definitive about the full answer.
I am working on a forecasting report that has many values, mostly in the millions of dollars. I would like to display my $ fields in the thousands of $ so that I can make the text font larger and most easily readable. How do I do this so that instead of, for instance, $2,259,123, I display $2,259.
I have One table(and designed form from it) in which i have recording the daily transactions(it is like a daily book). Daily transactions took place like Purchase of items of Amount 45, sale=70, sold on account=100 etc.
What problem i am facing is: I would like to Add Cash In Hand amount and would like to show it on my form. When day end I would like to move remaining cash In Hand on separate column of that date. The next day i would like to take the previous Remaining Cash in Hand as Cash In Hand at Start for next date and so on.
I have been an MS Excel man all along my career and I am a novice in MS Access.I have created a table, [Initial Customer Approval] which records data from a Form, [Initial Customer Approval]. Once the data is entered in the Form, I need to do some calculations based on the data entered in some of the fields in the form.I created 6 different queries for the six possible values in those fields. now for each of those queries I created respective reports.I placed a Print command button in the Form.
1. When I press the Print button it should open the report for the current record in the Form. (Currently It Opens all the reports simulatneously, with only one relevant report containing the current record; other opened reports being blank.)
2. If user presses the Print button before pressing Save button then system should prompt user.
Here is the code (Please note [reference number] is the unique ID generated for each record entered in the tabe through form):
Private bSaveClicked As Boolean Private Sub Form_BeforeUpdate(Cancel As Integer) If Not bSaveClicked Then MsgBox "You are trying to navigate away from the active record. Please either save your changes, or press ESC to cancel your changes.", vbOKOnly + vbInformation Cancel = True
I am still trying to get a hang of development in access 2010.
I would like to design a form with a listbox or a combobox which holds all 8 of my reports (a table has all the reports), with a Print and a Preview view buttons. In addition, the user must be able to select if they want to view the report by month, quarter and the year in question.
How do i have a specific report print or previewed based on the value selected in the listbox or combobox and the date criteria.
I have a database of high-school football players, and I am looking to print out single page reports (or forms) that will show detail from several tables and queries. This will act as their resume when they visit schools on recruiting visits. The reason for needing query items, is that I have developed queries that return the most up to date height, weight, 40 time etc., and that single most up to date number is what should print, not the entire table. When I try to build a report it will let me bring in multiple tables, but not queries.
In Access 2003 I have a form, at the footer of which I want to put some summary information. One of which is a count of the number of purchases over £500. I have tried many variations after searching the posts on this site but the only one which does not return me an error of some kind with the expression is
=IIf([Bought For]>"500",Count([Bought For]),0)
where 'Bought For is the reports listing of the purchase prices in a given date range when opening the report, but the value returned in my test is '0' when it should be '2' as the test file has two purchases of over £500.
I am trying to make a report in which I can see the amount of money that I have to pay weekly to an employee. To explain myself clearer, I have different rates for each employee. For example:
NameNormalPayRateVacationPayRateSickPayRateOvertimePayRateStandbyPayRate John Smith$15$10$15$30$8 Ken Jonson$10$8$10$20$8
I am doing this in a query. So what I want to be able to do is, for example, take 4 hours that the employee worked at NormalPayRate and multiply it. But if tomorrow the employee worked at a different rate, for example 3 hours overtime, I want those 3 hours multiplied by OvertimePayRate.
The way I saw it on my Google researches, is that they have only one rate and the amount will be [SumOfHours]*[Rate]. But how can I tell my query to skip, for example, one rate because the employee didn't work at that rate that day. So I can have different amount for the different rates.
By the way, entering the information I can divide at what rate the employee worked x day. So if the employee work 6 hours at regular, and later on 4 hours at standby, I have those information separated in my table.
Results that I am getting: I can easily get the amount in money multiplying the whole hours by a rate, so my result in my report will be multiplied by the same rate.
how to change default currency in Access 2013 to a "foreign currency" (i.e. to Indonesia Rupiahs) without changing control panel (Region/Language>currency) - now setup as USA ($US)?
Every month, I create 15 individual reports with each report filtered by two fields, let's say Dept and Exec. You change Dept and Exec via a combo box drop down based on a table, and this information is passed to the query behind the report. Now, I repeat this process for every report. I use an unbound form that gathers the "Title", which is the Dept Name +"Special Report"; report Date using "as of" [DATE], and an updated through [Second Date].
Each monthly set of reports is sent to a new directory and folder (i.e. M:MOR Reports2005January. This changes each month. Somehow, I'd like to automate this where each report prints with its name to a newly created folder in pdf format.
I have been reading prior posts and am coming up with some ideas like adding a "selected" field to the Dept/Exec table and then step through those selected records to determine which report you are running. It takes a long time to print these to pdf in a new directory every month.
Is there a roundup function in access? I need to complete a calculation, using a rounded dollar value. If the dollar value is $15, keep it as $15...if it is anywhere from $15.01 to $15.99, I need the value to round up to $16.
In this case, I want to calculate a total for an order. If the LineTaxExempt field is checked (meaning tax exempt), the total is figured by the ([Qty] field X [Price] field)+the [ShippingHandling] field.
If the LineTaxExempt is not checked, then the above total, including shipping, is multiplied by 6% sales tax or 1.06. I then want this value rounded up to 2 decimal places. This control is a running total of the order.
This works most of the time, but I have run into a few rounding errors.
For example:
With exempt checked
1(Qty)X27.90(Price) + 6.44(ShippingHandling) gives me $34.35 instead of $34.34
With tax exempt checked (and multiple lines)
2(Qty)X141.02(Price) + 0.00(ShippingHandling) 10(Qty)X4.12(Price) + 0.00(ShippingHandling) gives me a grand total of $323.25 instead of $323.24
It's frustrating because it seems like it works part of the time and rounds wrong the other part of the time. By "rounds wrong", I mean I set it wrong to round.
Is there a better formula to use in a form or query to round up to 2 decimal places other than the =-Int(-Sum([Fieldname]) * 100) / 100 method that will give me the right results?
Any help/examples would be greatly appreciated on how to modify this to give me the correct result each time.
Here are my field types:
QTY ------- Field: Double Format: Standard Decimal Places: 2
Price ---------- Format: Currency Decimal Places: 4 (some unit prices are 4 digits--Example $1.2525)
how to print mutiple "invoice-records"..I want to print multiple times the same report but with different values ex. invoices (based on a query). I have the report and the queries ready but how can I automate this task?
This may sound I guess you could say stupid but...... Is there a way to add a less than symbol in a colum and still keep the value a number rather then text?
I've got a small form with one field called 'Price', this is set as a Currency type in the table design. How would I go about ensuring that the field (in form view) always starts with the '£' symbol...would this be an input mask or would it be something on the form?
I accidentally (really don't know how I did it) deleted the dollar signs from the entire database that I use daily. I did not set this database up, and don't really know how to much more than enter the data, and do basic stuff. How can I put the dollar signs back on all the forms/queries/reports that I use daily?
