Search results

I'm using Access 2010. I set up conditional formatting in some areas of my report. They're very simple like if a cell is between 0 and .4, then the background color of the field is red. They work just fine...when I click on the field. I don't remember ever running into this issue in the past...

Greetings. I have a report that I'd like to create a scorecard within. The scores will be expressed as percentages. I have 8 categories of tasks, and each category has a differing number of activities within it. When an activity is completed, the user checks a box indicating it is done. So I'd...

Hello all. I have a simple database out there in use for registering participants in a class. The folks running the class would now like to limit the participants to 45 for a given day the class is given. Basically, they don't want to register more than 45 people for a class. So, how do I...

I have a report in Access 2010 whose control source is a query. When the report is launched, the query asks the user for a date span to filter the results with. The user enters the start date in MM/DD/YYYY format in the box and then the same for the end date. The report filters the dates just...

I've search and found several threads on this, but none seemed to fit with what I'm doing. I'm updating a database created by a guy who retired 6+ years ago. His formula for determining the person's age using today's date and the person's date of birth adds a year most every time. I've...

So I made a little db using A2k3 to use @ work. We have OpenOffice.org 2.0 @ work and not MS Office. Since I knew Access better than OO's db program, I used it and was going to just take it in and use it after it was finished. Well, I didn't realize that unlike OO's Word, PowerPoint and Excel...

I have a form that calls a report that's based on a query. That all works peachy. The report comes up with the requested info. My question is how do I get the report to be on top and the form it was called from to go to the back? I want the form to stay open so after I close the report I can...

My table was fine and I went in to add a field. I did so and got this error when saving: "Compile error. in table-level validation expression." I went thru all my fields and I have no validation rules established. I tried removing the field I added and still have the same error. I used the...

I have this expression: =IIf([Text131] Between 16 And 30,"Unacceptable",IIf([Text131] Between 31 And 42,"Marginal",IIf([Text131] Between 43 And 56,"Effective",IIf([Text131] Between 57 And 71,"Very Good",IIf([Text131] Between 72 And 80,"Outstanding",""))))) It works just fine, but I was...

I have a form on which people are scored. There is a field [TotalScore] that sums the scores as they're selected (1 thru 5 in a combo box) on the form. This portion works fine. However, getting that sum to the report is where I'm having trouble. Since the control for the form field...

Hello. I have an Iif statement where based on the number in the [Score] text box, a certain phrase is displayed in the [Ranking] text box. For instance, if the score in greater than 0 And less than 49, then a phrase such as "Try again" is displayed. If the score is greater than or equal to 50...

I have a performance evaluation db in MSA 2003 I am about done with. I had asked a question and got a helpful response. However, the response mentioned normalizing so I hit up google for more info. My db is not normalized, but after reading several sites, I don't see why I need to normalize...

I have searched on this forum for other threads like this and in the db examples page, but didn't find anything. I have made a perfomance eval db in MSA 2003. It works fine except for one part. I need to score the individual on about 20 different criteria. Each one ranges from 1-5. I am...

Greetings. I don't even know if this is possible, but what I'd like to do is have a list, separated by commas, generated on my report for each checkbox checked on the form. So a question on the form could be "Check the movies you own." Then on the report, each box that was checked would be...

I have refined my earlier question to the group. I set up a query that has all the fields of my table. I have a report that draws the records from this query. The first set of records come thru just fine. However, the report needs records for 7 days (all days of the week). The report needs to...

I have refined my earlier question to the group. I set up a query that has all the fields of my table. I have a report that draws the records from this query. The first set of records come thru just fine. However, the report needs records for 7 days (all days of the week). The report needs...

I have a report set up that I want to add records to on specific dates. On the first day of the week, ActualSales and all that go in just fine. However, I want to report to enter ActualSales on the next day in the correct spot. I have a field called StartDate, which is the date of the...

Instead of a new record being put below the previous one, I want a new record to go to the right of the last one - in columns. I created a columnar repoty, but the format is still the standard where the new record goes under the previous record. How do I get the new record to go to the side of...

It was suggested I learn more on normalizing to reduce the headaches in my report which is generated from tables. I went thru and trimmed some fat and came up with 2 tables as listed below: tbl_ShiftNumbers: Date CustomerCount ActualHours LaborDollars NetSales tbl_DailyResults: Date...

Greetings. I am having trouble with a report that I think is a simple one to solve for someone who has spent a little more time with Access than I have. Anyhow, I have 7 separate tables which are populated by data from 7 different forms. Each one corresponds to a day of the week. I then...