Search results

I need to calculate the number of days divided by 180 times the number of Units and have it return a number with 7 decimal places. My calculation keeps dropping the decimal places. As an example, I have two (2) fields in my table: Field Name Data Type Field Size Units...

I have an Access 2010 database that tracks Classroom Training. I have a "Start Time" field for each class and a "Duration" field for the length of each class. The Start Time field is a date/time data type and the Duration field is a number data type set to Double with 1 decimal place. Example...

Hello, I am struggling with how to accomplish this. I have an Access db of tblstudents and tblTeachers. What I have been assigned to do is create a button on a Form that when clicked will: take the students from tblStudents who are registered for Algebra I and assign then to the Teacher in...

I am working on a Payroll report and have totaled up the number of "sick days" used. This number for one individual totals up to 6.375. (He has used 6 days and 3 hours). Our work day is equal to 8 hours. When I use the Round function on 6.375 it displays as 6.4 but I need it to show the actual...

I am trying to develop a elementary school competition database and one of the options the users would like is to randomly generate teams from the registered students. The divisions would be grade 3 against 4, 5 against 6, and 7 against 8. They would also like to have 10 students per team and...

I am trying to use the transferspreadsheet to export Access 07 query to Excel 07 with file extension of xlsm. I am receiving a runtime error 3027. It works fine if I use file extension of xlsx but I need the workbook macro enabled. Any thoughts or suggestions?

I need to report the top 10% scores. Here is my query when selecting "All" values. I have 20 records so the 10% value should show me two (2) records but since I have a tie in the second value I should get 4 records. Total2Team NameSchool District Name22Ancient HistoriansFranklin Area21Ancient...

I have a Student Disciplinary database that consists of many schools with a primary key on SchoolID. The database will be accessed by all of the schools. Is there a way to restrict/allow a user(school district) to view only his/her school data. Thank you

Hi all, I have a Mainform with a subform. On my Mainform I have a textbox [txtOperator] containing a value list of math operators (=, >, <, <>, >=) and a textbox [txtRSS] where the user may enter a score. So for example, the user may search for everyone who has a score = 1200 or maybe <> 1200...

I have a form with a combo box containing the names of the Months. What I want to do is then pass the Month name to a query as a date range. For example, select "May" from cboMonth and the query will check the date field for "between 05/01/2008 And 05/31/2008" Here is what I have in my query...