Search results

I'm teaching this term, and have put my grades and roster in Access. Each grading opportunity is a separate field. Students will have to take 3 exams (Exam1, Exam2, and Exam3); however, their grade is based only on the 2 highest exam grades. There are other grades...FinalPaper, Attendance...

Is there a way to change the formatting of a cell, based on the value? Like the conditional formatting option in Excel? I have a yes/no field, and in the report, I'd like the NO values to be red and bold. Thanks. Gayle Ann

I designed a database for someone at work, and they wanted the report in a datasheet view. Now, they would like every other row shaded. Is there a way to create that type of display? Thanks. Gayle Ann

I have a report that displays a checkbox. However, I want to export the report to RTF or some format ti use as an e-mail attachment, and when I do, the checkbox disappears. I've also tried exporting it to Excel. In a query, I changed it from a checkbox to a Yes/No textbox, but the checkbox is...

I'm doing a table regarding employee hiring and evaluation. I have 2 fields: Last Promotion Date Last Evaluation Date I want the defalut value for Last Evaluation Date to be Last Promotion Date. Is that possible? I keep getting an error message when I am in the table design view, which...

Hello, I'm doing a query that calculates the number of days between NOW() and the date of hire. I'd like to have a field called probation, that displays the word probation if the employee has been with the company less than 181 days (probabtion being 180 days). I think I need an if/then...

Hello, I'm working on an employee incident database. In my main form, which is the actual incident, I have a subform of employee information. One of the fields is a combo box that draws off of a query, which draws from a table called Staff Names. The query, staff name sort, sorts the...

How can I set the combobox list to refresh? I have a macro to open a form to add a new record if the record needed is not in the table/query on which the combo box is based. However, when I close the form used to add the new record, the new information is not in the combo box in the original...

Hello, I have a subform which is a datasheet. Is there a way to set the column width? I've tried in the properties, and using the menu, etc. My fields are case number, employee name, and a Yes/No column. Obviously, the employee name can expand or shrink the column, but I'd like to set the...

I'm doing a database with employee records and a subform of employee work assignments. The primary key is the employee ID. I know this is a common procedure, but... How can I have the form take me to the employee's record if it already exists, or begin entry of a new record if it doesn't...

Hello, I have three forms (one main and two subforms) I can't remember how to go from the last field in one subform to the field in the next subform. My thought was to do it through the ENTER key. Tab, going to a new record in the same subform, and Enter taking me to the next subform. I...

Hello, I have few reports with 2-3 columns. A few of the fields are numeric, and I had the wizard calculate, sum, avg, etc. Hoowever, when printed the GRAND TOTALS are somehow forced to a brand new page. They won't print out at the end of the info form the last column. Example: One report...

Is there a way to create a "template" so to speak, so that when the material is updated, the graph is updated. I'm tracking the number of employees in disability by week for 4 months. I'd like to have two graphs, based on two queiries: 1. by site 2, THe company wide total I am finding this...

I have a table, used in a form, that records general information about employees, including an employee ID number. I also have a second table, called Duty Assignment, that is linked to the Employee table by the employee ID nmber. The main form is the employee table, and the subform is the Duty...

I want to greate a graph based on my data, but one that is automatically updated everytime the data changes (i.e. month vs. employee overtime or month vs. commissary sales). Is that possible? Also, the only way I can seem to get ANY graph I great to print as it is viewed on screen is to...

I have a table called staff injuries. It has a check box field to not an outside referral to a hospital, etc. It is called OUTREF Because I am interested in things like average number of accidents/week, etc. I also have a check box field called NONE. That way, the correct number of weeks...

I'm tracking overtime between various locations. Each site has to sumbit a weekly summary of their activities. I'd like to calculate the %change in overtime from week to week. How can I do that task? Thanks! Gayle Ann

Is there a way to calculate summaries for text fields? I am designing a database for work. There are 33 sites. I have a table that records the new employee injuries by week and site. I can do a count and determine the total number of injuries per site, but I'd like to know the average per...

I have a table called Staff Injuries. Each record is linked to a primary table through two fields: site and week, both of which are primary keys. (Thanks to someone for suggesting a compound primary key). This is a secondary table because it can have more than one answer. While the record...

Hello, I am designing a database with the informatin in weekly reports submitted by 34 different sites. A few of the questions can have multiple answers (ex. staff injuries). I have a primary table comprised of fields from questions with only one answer (ex. number of employees). The primary...