Search results

I failed Math. But Thank You for the reply. Very informative.

Thank you both for the quick reply. I guess I will try and convert as string and try formatting the field. Can someone tell me why though when you perform the calculation on a calculator it displays as: 6.0999993, just curious. (122/180)*9 = 6.0999993 Thanks for your help again.

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

Not a sharepoint web db, just a plain Access db. I have no coding experience can anyone provide me some direction on how to read in one table and assign limited amount of records from another table ?

Thank you for the quick reply. I already have the db created. Data is actually generated via a web site registration for schools. My db links to the web site tables. I am looking for help on some code to place behind a command button that will automatically assign the students to the teachers...

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

Sess and Steve, tried each of your suggestions and BOTH worked perfectly. Thanks so much, really appreciate the help.

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

Adam, sorry for the delay at posting my db but was on vaca for a few days. I've used to select Case to assign teams, there is probably a more efficient way to do this but I'm not sure how. I've got the students onto teams but now is there a way to make sure that grade 3 plays against 4 and 5...

That would be awesome!! I will try and post within the next day or so. Thanks so much.

Adam, thanks very much for the quick reply and code offer but I'm definitely not good with code, looking for a much easier route if that is possible. Thanks again.

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?

Sorry for the garbled mess. I will try your solution and let you know. Thanks very much, I appreciate your quick response.

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

Thanks very much for the quick reply. I'll check into this.

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

I appreciate the reply. Thanks for your advice.

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