Search results

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...

Thanks to everyone for your input. I think some reading is in order. I've never taken any db or Access classes. Everything I know I have learned on my own. I'm learning VB right now to help out. I need to do some reading on normalization since it appears to be the smart way to organize data...

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...

Thanks for the help. I did a little research on normalization and it gave me some ideas. I appreciate it.

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...

ListBox, I mean.

Instead of just creating a box and writing the day in on the report, should I have a SelectBox or something?

I've never used a CrosstabQuery. I got one in the works, but exactly where do I create the column headings (days of the week) Access is asking for? Thanx for your help! James

Ok. Rewind. I should have mentioned this earlier. I am not using the traditional design for my report. Ususally, a new reord in added under the previous one. In that design, it is working. Each record has generated a new page with the data. However, I want each record side-by-side for the...

Oops. Missed the '>' sign. The Date fields are fixed now, but all the ActualSales fields give the same figure - the one from the first record I added for testing. Thanx. James

I don't know how to get Access to work out the first day of the week so I had the user input it. Having Access work it out would be a much safer and more reliable method. How do I go about that? Also, I put [FirstDate] into the criteria field of [Date], but date fields on my report...

My fault. Didn't know which heading it was more appropriate for.

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...

I believe you just set the "Can Shrink" property to yes for that report.

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...