Recent content by jmccullough

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.