Search results

Thank you. I'll take a look at it. The form requirement is no problem, since I use a form and a combo box to select the year that represents the criteria for two of the queries in this report. I can apply it to that form.

Thank you for the clarification, I posted the data type for the percentages in post #8 above.

Yes. I stand by that. ;)

Are we talking about my AvgOfDistribution field? I assure you, there are no hidden ones. By that I mean no minute amounts. If there are 4, then $227,380.85 is $227,380.8500. The DistributionAmt field and the NotRounded field (which I only added to compare when I round or don't round each), I...

It is ok if one or two get a penny less; that is to be expected. I just need a consistent methodology and function for achieving that and not going over my exact amount. All calculations (sums as well as multiplications)? Because I wouldn't think the round function would have an effect on...

So I have gotten a lot of great tips and education from this site for a couple of months now. I guess I should share a little about who I am and what I'm doing... My name is Misty. I am an analyst for a local government office that deals with emergency data. My duties have shifted a bit lately...

The percentages are provided to me by one of our providers. They are exactly as they appear to be because I have hand-typed all of them into my original table. By that I mean, when I read her list that says: 23.0%, 18.5%, 16.0%, 2%, 25.5%, 7.5% and 7.5% (which adds up to 100%), they aren't...

Unfortunately, this is REAL money I'm working with, and we won't be cutting drafts with the 3rd and 4th decimal places. I am bound to working with a $0.00 format for the end result. The numbers on the report have to add up properly. Everyone is going to get a piece of the pie, and the numbers...

Yes. However, when this report goes public, all the values in that column have to accurately add up to the $227,380.85. FWIW, I could never find a rounding function in excel that would fix it in the past. I solved the issue by figuring the first 6 percentages and then subtracting the sum of...

The total should be the same as the original amount I started with. I am starting with an ACTUAL $227,380.85, applying percentages that add up to 100% and then adding those calculated amounts back together and getting $227,380.86-- one additional penny. So this won't work. Here is the...

What I meant by that is that this particular field there is no value past the 5. When you put your cursor in the record, it will expose the digits after the decimal (see second pic). The value in the first pic does not. Not that the first value has anything to do with the issue. I will try a...

I just double-checked. All money values in the table are in fact designated as currency. I also double-checked the queries and found a few places where the property sheet for a field in a query didn't designate as currency, but it was pulled from the table field in currency data type. I went...

I have converted a beast of a spreadsheet into an access database. I am working on a query that is being used for an access report. Here's the gist of what it does: The amounts in here are currency, and there is a specific amount, so coming up a few pennies more or a few pennies less is not...

This solved my problem. The new table (and yes, I added the autonumber primary key afterward) fixes it. Added benefit is two queries that are used in this report can run from the same combo box! SELECT tblDistribution.DistYear, tblDistribution.Order, tblDistribution.ZoneOrder...

Thank you. I used a combo of MakeTable, Append, and Update Queries to put the data into a new table... I will report back if I am successful in writing my query to accomplish what I need.

Thank you for the clarification. I need to think about this and how to get the information into that format. This project is my attempt at converting a huge, clunky spreadsheet (that has been passed down through multiple hands) into an elegant format that will produce the annual report with...

There are only 30 rows in this table. It would not be difficult to parse the year fields into different tables, if that is what you are suggesting would be the better way...

I have some fields not included in the pic of this table for privacy reasons; "City" is one of them. I have intended to use a query instead of a table in this particular query. That is the part I am having trouble with. I do have city in my table. I did not include it in the previous pic for...

OK, I am stumped on this one. I have a project in which I will be using a form's combo boxes to provide the criteria in a query in order to generate a report. My problem is that I have a table that has multiple year values. Here's the table: I want to have a combo box direct to one of the...

That works, and I'm able to click "Open" on it and the on load works after that. However; I find that after the first time, subsequent openings it still pops up the "Microsoft Access Security Notice". Is there a way to make it not do that after the first opening?